MySQl 4.1.3-beta-standard
Note: Due to problems that the current version has with creating new tables that already exist I have to use this version (which works properly). I'm not aware if the create issues have been addressed in the current version but until then, I have run into the following issue which may or may not effect current versions of MySQL.
I've a text field that contains something like:
Field1 (text)
============
this
is
a
test +
============
When I do a WHERE statement of: instr(`Field1`, '+')
I'm getting back all 4 records; which is incorrect
If I do the following: instr(`Field1`, 's')
I get back 3 records; which is correct
Is the plus sign a special character within a text field or is this a bug?
TIA
Sean Shrum
http://www.shrum.net