Обсуждение: whats the standard text search query?

I have this small web aplication.
When i used mysql i used to do somthing like:

SELECT * FROM table WHERE name like '%searchstring%' OR description like '%searchstring%';

that doesnt really looks eficient... well... actually it works with no problem.

anyway... what's the standard query for a text search?

thanks in advance

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