[SOLVED] Re: #1191 - Can't find FULLTEXT index matching the column list

2006-05-12 Thread Afan Pasalic
Hi Sheeri No, I wanted to search through both columns in the same time (and it will be always at the same time) - the problem was I didn't know that I have to have one multi-column index. :) But, it's fixed (after really helpful comments on this mailing list) and works perfect :) Thanks to

[SOLVED] Re: #1191 - Can't find FULLTEXT index matching the column list

2006-05-11 Thread afan
Yup. The problem solved! Thanks John! ;) -afan > [EMAIL PROTECTED] wrote: >> Ok. Got it. >> And, since the able is already created and with tons of products inside, >> how can I change the FULTEXT index? >> I'm using phpMyAdmin. > > Just create a new index. > http://dev.mysql.com/doc/refman/4.