Re: Free text search in MySQL

On Wednesday March 30 2016 13:04, in
comp.databases.mysql, "bit-naughty_at_hotmail.com" <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....

  SELECT column FROM table WHERE text_key_column LIKE '%rat%';

-- 
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request