Bug #1003 mysql error
Submitted: 5 Aug 2003 10:09 Modified: 5 Aug 2003 10:31
Reporter: William Wang Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:MySQL 4.0.13 OS:FreeBSD (FreeBSD && WIN 2K)
Assigned to: CPU Architecture:Any

[5 Aug 2003 10:09] William Wang
Description:
I have a table field defined as set
This work
SELECT * FROM tblName WHERE FIND_IN_SET('1',tblField)>0

but when there is a space between FIND_IN_SET and ('1',tblField), I got an mysql error.

How to repeat:
I have a table field defined as set
This work
SELECT * FROM tblName WHERE FIND_IN_SET('1',tblField)>0

but when there is a space between FIND_IN_SET and ('1',tblField), I got an mysql error.

Suggested fix:
Should be able to put a space between "FIND_IN_SET" and "('1',tblField)"
[5 Aug 2003 10:31] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

MySQL does not allow space between function name and parenthesis