ÀÌÀ±¿µ writes:
> hi all!
> coding a database search program on web,
> i want to have that pg to find tuples including
> the string that a user inputs.
> how can i do?
> Does Postgres supply built-in function such like strstr()
> in C ?
> I'm wating you.
> ------------------------------------------------------
> Yoon-young Lee from Korea
> ~~m..m~~
You can use the SQL "like" operator and do something like:
select *
from table
where field like '%somestring%'
The "%" == zero or more of any character.
Jonathan
--
Jonathan H. Wheaton
jwheaton@applink.net