Re: Free text search in MySQL

On 3/30/2016 1:04 PM, bit-naughty_at_hotmail.com wrote:
> Hi,
> If I have the text "A rat in a hat" inside a MySQL DB, and if on my webpage someone searches for the text "rat", I would like them to get that line - how do I do that?
> I realise that this sort of *precludes* my previous question about fuzzy matching, but I would still like to know....
>
>
> Thanks.
>

I would suggest looking into a regex. With that you can find 'rat' whether it's in the middle of the sentence like above, or at the beginning or end of a sentence (or line, for that matter) without false positives like 'rattle'.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================