Sorry...
I read mysql page and I read that is need mysql 4 and my server only has
mysql 3.23.51!!!
I'll try to contact my ISP in order to they update the server.
Thanks all,
Nuno Lopes
> 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]
