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]
