Re: Free text search in MySQL
Date: Wed, 30 Mar 2016 15:25:38 -0400
Message-ID: <ndh91g$igh$1_at_jstuckle.eternal-september.org>
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."
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Wed Mar 30 2016 - 21:25:38 CEST