On Wed, 21 May 2003, Thomas Corell wrote:
But (never without a but;) I think 2 types of seaches are needed most:
- 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)