Hi! You can try FULLTEXT search, implemented in MySQL, or consider installing specialized Web search engine.
Eivind A. Sivertsen wrote: > I run a MySQL/PHP-based website. In an attempt to make some search > functionality, I search a few specific tables that I find relevant and look > in certain fields when performing a search. A query will generally look > something like this: > > SELECT * FROM Books WHERE LongName LIKE '%$kw%' OR ShortName LIKE '%$kw%' > > When searching through multiple table groups (i.e. Books, Tapes, > Furniture....(bogus examples)), search results are simply grouped using php > and presented in the sequence they were found. > > I dont find this to perform adequately as the site grows, especially since I > have not been able to implement any response relevance measure with this > scheme. I have heard this could be accomplished using some temporary tables > with MySQL....does any body know more about this? > I will also appreciate responses with suggestions for good search schemes, > particulary good resources on the subject (preferrably available on the web) > or any other tips and ideas. > > Best regards, > > Eivind > > PS. thanks for a sometimes very interesting list! ;-) > > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Barkov <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia <___/ www.mysql.com +7-902-856-80-21 --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php