om Johnson [mailto:[EMAIL PROTECTED]
> Sent: 26 June 2003 14:23
> To: [EMAIL PROTECTED]
> Subject: Need your help in a search query
>
>
> Hi MySQL Experts,
>
> I am pretty new at this and need your help in figuring out if it is
possible
> to create a query to search for words i
TECTED]
> Sent: Thursday, June 26, 2003 7:23 AM
> To: [EMAIL PROTECTED]
> Subject: Need your help in a search query
>
>
> Hi MySQL Experts,
>
> I am pretty new at this and need your help in figuring out if
> it is possible
> to create a query to search for words in
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is possible
to create a query to search for words in a given field. What I am trying to
do is allow a user to enter words to search for a given title in the
database. For example, a person is looking up the title