Hi,
A "dirty" solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or
field='one';
Regards,
Jocelyn
----- Original Message -----
From: "Beauford.2003" <beauford.2003@stripped>
To: "MySQL List" <mysql@stripped>
Sent: Tuesday, December 10, 2002 12:50 AM
Subject: Select * From table where name Like 'help'; Help
> Hi,
>
> Hey, did this list change their spam filters? Now every time I send an
email
> it gets bounced unless the word MySQL or Query is in the email. Anyway,
> Please read below for a recent problem I am having.
>
> I want to be able to search on my database and be able to get the
> following, but running into a few snags.
>
> If I search for the word - One - I want to see:
>
> Another One
> One Day
> One on One
> Your The One
>
> But not:
>
> Fashioned
> Stone
> Everyone
>
> Also, and maybe part of the solution - is there a way for the search to
be
> case sensitive.
>
> TIA
>
> Beauford
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread126958@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-joc=presence-pc.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
