Jim Winstead wrote:
For example:
SELECT record FROM table
WHERE MATCH (record) AGAINST ('resident*' IN BOOLEAN MODE)
(Using 'IN BOOLEAN MODE' requires MySQL 4.0 or later.)
I guess it is time to upgrade from 3.23, I'm using RedHat Linux and have
upgraded on some machines but it is a pain to d
On Fri, Dec 03, 2004 at 10:30:25AM -0500, Michael J. Pawlowsky wrote:
> I've been trying to implement full text searches.
>
> Genreally I use either LIKE or REGEXP for searches but wanted to try
> some Full Text Searches.
>
> It's wonderfully fast and is working well for full words, however I ha
I've been trying to implement full text searches.
Genreally I use either LIKE or REGEXP for searches but wanted to try
some Full Text Searches.
It's wonderfully fast and is working well for full words, however I have
not found a way to add wildcards in a search.
For example if in my text fields