Sql filter command only if column value not equal
I have SQL command it currently shows
1.Name (Person'e name) I only want that starts with AR
2.Country (ANY COUNTRY) But sort them ASC A to Z
3.Normal_State (this is given in Binary) Most of them 3 & 4 are equal
4.Current_State (this is also given in Binary) Only want to if they are not equal
1 and 2 I got it to work, I need help getting 3 and 4 for example
Not sure what you mean by "Most of them 3 & 4 are equal" and "Only want to if they are not equal"... these seem to be contradictory statements.
It seems you want the latter, so you'd want to add
Since you only have one table, you don't need the table reference before the folumn in the WHERE and order by columns.
Keleth is correct. In other words:
|All times are GMT +1. The time now is 03:04 AM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.