You are here: Re: PHP, MySQL and snippets of info ... « PHP Programming Language « IT news, forums, messages
Re: PHP, MySQL and snippets of info ...

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ń!"

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация