On May 30, 2006, at 12:46 , Pedro wrote:
SELECT * FROM table WHERE name like '%searchstring%' OR description like '%searchstring%';that doesnt really looks eficient... well... actually it works with no problem.
Depending on your needs, that may work just fine. PostgreSQL includes regex matching as well.
anyway... what's the standard query for a text search?
If you're looking for full text search, take a look at tsearch2 in contrib.
Michael Glaesemann grzm seespotcode net
