I'm having a problem with full text searching, probably just doing
something stupid but can't find it.
I have a full text index on 2 fields in my table, one field is a
varchar field 255 chars long. The other field is a text field.
When I query just one field with MATCH/AGAINST then there is no
problem but as soon as I query both fields then I'm getting an error.
SELECT * FROM `tscanner` WHERE MATCH (scanner_long_desc,
scanner_model) AGAINST ("amet")
I get the following error:
Can't find FULLTEXT index matching the column list
as far as I can see I'm doing everything properly. Any ideas?
TIA,
David
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
