Difficulty with SQL LIKE clause
| From: | David Freedman | Date: | Fri, 25 Feb 2005 20:27:54 +0000 |
| Subject: | Difficulty with SQL LIKE clause | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-209403@lists.php.net to get a copy of this message | ||
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.