Re: PHP, MySQL and snippets of info ...

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ń!"
Received on Tue Oct 18 02:30:19 2005