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 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! ;-)
Eivind,
Take a look at FullText index which is improving with each MySQL
release.
Mike
---------------------------------------------------------------------
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
