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
>('wor
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
On Tue, 12 Jul 2005 18:34:38 -0400, wrote:
>H, 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
H, how about using full text indexing? It will be a lot easier
to implement and a lot quicker.
On Jul 12, 2005, at 1:09 PM, zzapper wrote:
Hi
I have a piece of code which will search a series of records for
the presence of two keywords $key1
and $key2 (see below)
The client now wan
