Re: pattern matching in mysql
Date: Sun, 18 Apr 2004 10:01:33 +0200
On Sat, 17 Apr 2004 12:35:13 -0700, abracad wrote:
> I have a table, location, of place names eg
> Hong Kong
> New York
> 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?
-- mvh/regards Joachim Mæland If everything seems under control, you're just not going fast enough. -Mario AndrettiReceived on Sun Apr 18 2004 - 10:01:33 CEST