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 W

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 cert

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