On Tuesday, 26. February 2002 00:18, Craig Westerman wrote:
> What is proper way to define a variable to include all dates newer than > 1995-01-01? > What is proper way to define a variable to include all dates older than > 1995-01-01? > What is proper way to define a variable to include all dates between > 1995-01-01 and 1998-12-31? don't use LIKE for your statements. With LIKE '%$query%' you can't use an index too. USE >, < and = instead! e.g. SELECT fields from table WHERE date > '1995-01-01' Regards Georg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
