Posted by gardnern on 03/08/06 20:15

WHERE TABLE1.depart_day LIKE '2006-03-08%' AND TABLE2.depart_day LIKE
'2006-03-08%'

% = wildcard, but you must use LIKE instead of =

• Next in forum: New to OO programming
• Prev in forum: Re: UTF-8 and question marks
• Thread view: Re: Comparing indexed MySQL datetime columns

[Reply to this message]