On Wed, 13 Jul 2005 09:24:20 -0400, wrote:
>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.
>
O gosh my learning curve
Thanks
--
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/[EMAIL PROTECTED]
