Textmatchning - Mailing list pgsql-general

From A B
Subject Textmatchning
Date
Msg-id dbbf25900809171136g5f8829f9j39bef9f84b515f05@mail.gmail.com
Whole thread Raw
Responses Re: Textmatchning  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Textmatchning  (Edoardo Panfili <edoardo@aspix.it>)
Re: Textmatchning  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Hi.
I would like to compare two columns a and b and find all cases where
a is a part of b, like this
select * from mytable where a ilike b;

but that will not give me a row in the case  when a = 'foo'  and b='FOOTBALL'
and I want that to be a match.

So how do I rewrite my expression? I can't find any way to add % to
make it match the way I want.

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: 8.3.3 stability ?
Next
From: Tom Lane
Date:
Subject: Re: 8.3.3 stability ?