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]



Reply via email to