[ADMIN]substring check function

ÀÌÀ±¿µ 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(at)applink(dot)net