From: | Johan Daine <isis(at)wanadoo(dot)be> |
---|---|
To: | Patrick Coulombe <pcoulombe(at)mediacces(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: LIKE upper('%$info%') -- (like google) |
Date: | 2001-05-26 18:43:39 |
Message-ID: | 3B0FF95B.8BFDE095@wanadoo.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Patrick Coulombe wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
You might have a look at the regular expressions:
http://postgresql.mirror.easynet.be/users-lounge/docs/7.1/user/functions-matching.html#FUNCTIONS-REGEXP
http://www.opengroup.org/onlinepubs/7908799/xbd/re.html
Good luck
--
_/ /_/_/_/ Johan Daine
_/ /_/ _/ mailto:isis(at)wanadoo(dot)be
_/ /_/ _/ http://thot.dyndns.org:6080
_/ /_/ _/
_/ /_/ _/
/_/_/_/ /_/_/_/
From | Date | Subject | |
---|---|---|---|
Next Message | GCS | 2001-05-26 20:22:34 | Table joining problem. |
Previous Message | Patrick Coulombe | 2001-05-26 04:04:55 | LIKE upper('%$info%') -- (like google) |