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