Re: Free text search in MySQL

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Thu, 31 Mar 2016 00:25:54 +0100
Message-ID: <ndhna2$an1$1_at_news.albasani.net>


On 30/03/16 20:25, Jerry Stuckle wrote:
> On 3/30/2016 3:02 PM, The Natural Philosopher wrote:
>> On 30/03/16 18:32, The Natural Philosopher wrote:
>>> On 30/03/16 18:04, 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.
>>>>
>>> Pretty much 'select from table where field like '%rat%';
>>>
>>> Or ' %rat %' if you want the word rat by itself.
>>>
>>>
>>>
>> Um make that last line '% rat %'....
>>
>
> Which fails for "rat and cat." or "cat and rat." or even
> "A cat and a
> rat played together."

It also fails with 'I don't give a rat's arse'
>

Well Jerry, you know all there is to know about failure. Got a better suggestion?

aside, how did you get to be such a complete cunt?

Were you born like it, or is it years of dedicated study?

No.You never have

-- 
To ban Christmas, simply give turkeys the vote.
Received on Thu Mar 31 2016 - 01:25:54 CEST

Original text of this message