On Sun, 2002-07-14 at 08:53, Derek Barrett wrote:
>
> In my situation, I need to match exact words, so I've used regular expressions to search on a varchar(10000) field:
>
> SELECT *
> FROM table
> WHERE description ~* ('[^a-zA-Z0-9]($keyword[$x])[^a-zA-Z0-9]');
>
> Would this module still be useful in my situation?
I was doing word search with a modified version of the fulltextindex
code, but in the end I found it easier to write a perl program to do
build the index table - the trigger approach was more work to manage
than it seemed it should be.
Regards,
Andrew.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
Are you enrolled at http://schoolreunions.co.nz/ yet?