On Friday 25 February 2005 04:28 pm, Wiberg wrote: > Hi there! > > A little off-topic but what the heck (it's a more MySQL - related question) > > Is 197* a numbertype field? > Try maybe $query= "SELECT * FROM my_table WHERE Year LIKE '197*'"; > > /G > @varupiraten.se > > -----Ursprungligt meddelande----- > Från: David Freedman [mailto:eatc7402@xxxxxxxxxxx] > Skickat: den 25 februari 2005 21:28 > Till: php-general@xxxxxxxxxxxxx > Ämne: Difficulty with SQL LIKE clause > > > 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. Try: $query= "SELECT * FROM my_table WHERE year ~* '^(197).*'"; Hth, Andre -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php