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?
>
Try something lile
select * from friends where name ~* '(Patrick)|(Coulombe)' ;
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
_/ /_/_/_/ Johan Daine
_/ /_/ _/ mailto:isis@wanadoo.be
_/ /_/ _/ http://thot.dyndns.org:6080
_/ /_/ _/
_/ /_/ _/
/_/_/_/ /_/_/_/