grazzman Posted January 3, 2007 Share Posted January 3, 2007 Is their a way to do this?SELECT * FROM `User` WHERE RankType = 'Active' OR 'Retired'So that it will show any that have either Active or Retired and none of the others? Quote Link to comment Share on other sites More sharing options...
tcollie Posted January 3, 2007 Share Posted January 3, 2007 SELECT * FROM `User` WHERE RankType = 'Active' OR RankType='Retired' Quote Link to comment Share on other sites More sharing options...
jeeva Posted January 3, 2007 Share Posted January 3, 2007 You can write the query as you mentioned it wont through any sql error, but u cannot get the actual result what u are expected.It will return the first value even though the two conditions are satisfied. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.