Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: pattern matching in mysql

Re: pattern matching in mysql

From: Joachim Mæland <jm-news_at_profine.net>
Date: Sun, 18 Apr 2004 10:01:33 +0200
Message-ID: <pan.2004.04.18.08.01.25.770386@profine.net>


On Sat, 17 Apr 2004 12:35:13 -0700, abracad wrote:

> I have a table, location, of place names eg
>
> place
> -----
> London
> 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?

fulltext

-- 
mvh/regards
Joachim Mland

If everything seems under control, you're just not going fast enough.
-Mario Andretti
Received on Sun Apr 18 2004 - 03:01:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US