Re: Free text search in MySQL

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Wed, 30 Mar 2016 20:02:06 +0100
Message-ID: <ndh7re$ero$3_at_news.albasani.net>


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 %'....

-- 
Ideas are more powerful than guns. We would not let our enemies have 
guns, why should we let them have ideas?

Josef Stalin
Received on Wed Mar 30 2016 - 21:02:06 CEST

Original text of this message