On Mon, Jun 16, 2003 at 12:45:53PM -0400, Martin's - Web Dept. wrote:
> I am quite willing to acknowledge that I'm new at this ...
>
> But I can't find the syntax error in this query:
>
> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>
> desc is a field name, usb is the keyword I'm searching for.
'desc' is a reserved word. you need to surround it in backquotes when
using it as a field or table name.
SELECT * FROM products WHERE MATCH (`desc`) AGAINST ('usb')
There's more information about reserved words at:
http://www.mysql.com/doc/en/Reserved_words.html
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
