Skip site navigation (1) Skip section navigation (2)

LIKE upper('%$info%') -- (like google)

From: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: LIKE upper('%$info%') -- (like google)
Date: 2001-05-26 04:04:55
Message-ID: 00f901c0e599$0592fd10$05d1ca18@caroline (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
how can i search my database like a search engine (ie google).

-- $info= patrick coulombe
-- select distinct * from friends where upper(name) LIKE upper('%$info%')

i want postgresql to find :

-- patrick lefevre
-- coulombe caroline
-- patrick coulombe
-- coulombe patrick

you get the idea...
thank you :)


pgsql-novice by date

Next:From: Johan DaineDate: 2001-05-26 18:43:39
Subject: Re: LIKE upper('%$info%') -- (like google)
Previous:From: MilenDate: 2001-05-25 17:40:51
Subject: batch file

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group