PHP/Postgre Simple Search

[Anon]

I'm just a little lost on how I could do such a simple thing as searching through the database and having it retrieve rows that contain a word or string of text in a specified field. I'm assuming this is a simple operation but I just can't bring myself to dig through the postgresql.org documentation (which i think is horrible). Help me out if you can, thanks. 🙂

http://www.crudpot.net

[[deleted]]

SELECT field1, field2,...
FROM table1
WHERE fieldx LIKE '%searchword%';