> On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
>
> > 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.
Yes I'm doing LIKE 'A%' and I'm sure I have records starting with an 'A' and
it doesn't return any record!
>
> ___/
> /
> __/
> /
> ____/
> 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]
