Posted by Adam i Agnieszka Gasiorowski FNORD on 10/02/05 00:07

On 2005-09-21 10:21:39 +0000, "elyob" <newsprofile@gmail.com> said:
>
> This is an interesting point. I have a database that people search by
> retaurant name. I do a search "LIKE '*name*'". I know this isn't the
> best, but quite a few businesses start with the word "The". e.g. I
> might search for "Ritz", when I really want "The Ritz".
>
>


Use the famous MySQL FULLTEXT search instead-of
LIKE operator. It uses groovy FULLTEXT index on
all search fields (you have to let MySQL make one
by ALTERing the table), theretofore it's fast and
polyamorous and very easy-going and fast. Oh, yes
it is, yes it is! Groove is all around...Love, love...
>

-- 
Seks, seksić, seksolatki...<uri: news:pl.soc.seks.moderowana > <~|{ A.A }|
Oh, make me over! I'm all I want to be! A walking study...in demonology!
So glad you can make it! Now you really made it! So glad you are? We are!
https://hyperreal.info | https://kanaba.info |=> "Gościu! Szanuj Zieleń!"

[Back to original message]