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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 :)
patrick

Responses

Browse pgsql-novice by date

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