Searching through a MySQL-driven website

2002-06-26 Thread Eivind A. Sivertsen
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

Re: Searching through a MySQL-driven website

2002-06-26 Thread Alexander Barkov
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

Re: Searching through a MySQL-driven website

2002-06-26 Thread mos
At 05:00 AM 6/26/2002, you 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