Re: Free text search in MySQL
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'
>
-- To ban Christmas, simply give turkeys the vote.Received on Thu Mar 31 2016 - 01:25:54 CEST