pattern matching in mysql
Date: 17 Apr 2004 12:35:13 -0700
I have a table, location, of place names eg
and wish to search for any places in a user-entered search string eg "London Hong Kong"
In Access the query
SELECT * FROM location
WHERE 'London Hong Kong' LIKE '*'&place&'*' returns both Hong Kong and London
But in MySQL nothing is returned, even replacing the MS-specific * with %
How is this achieved in MySQL?
Thanks Received on Sat Apr 17 2004 - 21:35:13 CEST