In mysql 4.0.12:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );Santino
Hello,
I have a table with just one column and with 1000 rows. It's indexed using full text. I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried: SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvore*'); it returns some results. So, it only returns something when I pust the whole word in the query. It doesn't accept half a word with a *.
With LIKE, things are a little different! the query only works with & before and after the word. Ex.: %word% works but not word%.
Can anybody help me, please??
Thanks, Nuno Lopes
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
