Create a full text index that encompasses the fields you want to
search in (synopsis, title, keywords).
Then format your select to take advantage of the full text index:
select * from dbname where match(synopsis, title, keywords) against
('word1 word2 "phrase one" etc' in boolean mode)
You should read the manual on full text indexing since there are a
lot of options. You can do relevance ranking, adjust the importance
of the words you are searching on, etc. There are also limitations
you need to be aware of, like no relevance when searching in boolean
mode, can't be used on InnoDB tables, etc.
On Jul 13, 2005, at 2:17 AM, zzapper wrote:
On Tue, 12 Jul 2005 18:34:38 -0400, wrote:
Hmmmm, how about using full text indexing? It will be a lot easier
to implement and a lot quicker.
Can you give more details?
--
zzapper
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
