MySQL Forums
Forum List  »  General

Possible bug or is it me
Posted by: Sean Shrum
Date: November 01, 2004 05:04PM

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

Options: ReplyQuote


Subject
Written By
Posted
Possible bug or is it me
November 01, 2004 05:04PM
November 01, 2004 05:45PM
November 02, 2004 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.