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 30/03/16 20:25, Jerry Stuckle wrote:
>
> 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
>
>
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