MySQL Forums
Forum List  »  MySQL Query Browser

No records returned when query on primary field
Posted by: Nevin Reid
Date: February 08, 2005 02:55PM

Hi,
I'm using the Query Browser to test a problem I'm having with one of my pages and it appears to be an issue with one of the tables. I can query and return all records, and return ones with a condition on any field except my primary field. When I ask it:

SELECT * FROM servicerequests s
WHERE ServiceRequestID = '2004S10'

no records are displayed even though it is clearly there. There are no spaces around the data (I even did a copy paste into the query) and it won't work or any of the records. But if I use LIKE '%2004S10%' it works. All the other tables in my DB will return results on the primary index fields, so why won't this one?

Thanks for any help

Options: ReplyQuote


Subject
Written By
Posted
No records returned when query on primary field
February 08, 2005 02:55PM


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.