Using OR in a mySql string

[grazzman]

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?

[tcollie]

SELECT * FROM `User` WHERE RankType = 'Active' OR  RankType='Retired'

[jeeva]

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.