whats the standard text search query?

[Pedro <pedro100@xxxxxxxxx>]

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