Re: Free text search in MySQL

On 3/30/2016 7:25 PM, The Natural Philosopher 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."

>>

Yes, stoopid has-been ditch digger, I do. And I posted it. But I don't expect you to understand it.

It's the big reason you don't use your real name. You're terrified people will find out how stoopid you really are.

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