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 *.
MATCH...AGAINST works with full word indexes. Wildcards don't work.
With LIKE, things are a little different! the query only works with & before
and after the word. Ex.: %word% works but not word%.
It will work with 'word%' only if the first four characters of the field are 'word'. Similarly, '%word' will match only those records with 'word' at the end of the field. With '%word%', it will match if 'word' appears anywhere in the field.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://opentech.leafe.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
