Hi, thanks for your answer.
I tried what you suggested:
select table1.id,table1.name from table1,table2 where table1.textid=table2.id AND match(table2.text)
AGAINST('$searchString' IN BOOLEAN MODE);
But that query takes for ever to run and uses 100% cpu. Is there a faster way to do this query?
// Fredrik Carlsson
Egor Egorov <[EMAIL PROTECTED]> wrote: >Something like: > >SELECT ... FROM one, two WHERE textid=two.id AND MATCH(text) AGAINST() ..
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]