On Wed, 21 May 2003, Thomas Corell wrote:
But (never without a but;) I think 2 types of seaches
are needed most:
1. Search parts of title ( cur_title like "%query%" ), possibly a regex
(rlike '.*query.*') would be better.
Or boolean fulltext search:
http://www.mysql.com/doc/en/Fulltext_Search.html
Add on:
If we (developer) create a 'search_title' field in the DB, we can do:
[cur|old]_search_title = Language_depending_converting_function(cur_title)
See treatment of si_title field in searchindex table.
-- brion vibber (brion @
pobox.com)