postgresql - PHP search function to look in pgsql table -

i want make search function in website. want search string in fields of table (about 13 columns). if 1 row contains field matches string (like operator) want added result.

example

|field 1 | field 2 | field 3|       string     test      test           string  1       simple    string 

now if search string "test" want have first 2 rows.

is there wildcard option :

select * my.table * '%string%';

there no such syntax in postgresql (or other dbms).

as spudley pointed out using query like '%string%' quite slow.

if needed should postgresql's full text search capabilities.