You should use a _ instead.
Please have a look at the mySQL manual: http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html
Christian
When I use this query in PHP it works, and I get all things with the YEAR of 1977, as I expected.
$query= "SELECT * FROM my_table WHERE Year LIKE 1977 ";
But, when I use this query it does not work.
$query= "SELECT * FROM my_table WHERE Year LIKE 197* ";
I thought I should get the result of ALL things with the years in the 1970's (1970-1979). But the asterisk in the LIKE clause does not seem to work. I have tried various syntax's to try to get the 197* recognized but without any luck.
Can the '*' be used? What am I doing wrong.
David F.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
