MySQL Forums
Forum List  »  Newbie

whats wrong with my where clause?
Posted by: Jim Babcock
Date: September 08, 2004 10:35AM

Hello,

I'm a "fairly" adept oracle user and have recently moved to mysql and can't figure out why my where clause isn't working. I've been working with the MySQL Tutorial and even though it looks exactly whats in the book, its not working.

A select distinct returns:

mysql> select distinct machine from fs;
+-------------+
| machine |
+-------------+
| 'MBCAST' |
| 'SMSC0' |
| 'YOUNDNS01' |
| 'YOUNMS01' |
| 'CDS' |
+-------------+
5 rows in set (0.47 sec)

but my select with with a where returns:

mysql> select * from fs where machine='CDS';
Empty set (0.07 sec)

mysql> .

Options: ReplyQuote


Subject
Written By
Posted
whats wrong with my where clause?
September 08, 2004 10:35AM


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.