Re: Free text search in MySQL

From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Wed, 30 Mar 2016 22:38:41 -0400
Message-ID: <ndi2dg$ejr$2_at_jstuckle.eternal-september.org>


On 3/30/2016 7:25 PM, The Natural Philosopher wrote:

> 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
>
>

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
==================
Received on Thu Mar 31 2016 - 04:38:41 CEST

Original text of this message