CodingForums.com - Sql filter command only if column value not equal

CodingForums.com (http://www.codingforums.com/index.php)

- MySQL (http://www.codingforums.com/forumdisplay.php?f=7)

- - Sql filter command only if column value not equal (http://www.codingforums.com/showthread.php?t=266982)

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

Code:

SELECT

 NAME, 

Country, 

NORMAL_STATE, 

CURRENT_STATE 

FROM SOMS_TABLE 

WHERE SOMS_TABLE.NAME LIKE 'AR%' 

ORDER BY SOMS_TABLE.Country ASC

for example for image below I only want red one's to show up Thanks
http://i.stack.imgur.com/fXhnC.jpg

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 AND NORMAL_STATE != CURRENT_STATE before the ORDER BY.

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:

Code:

SELECT  NAME, Country, NORMAL_STATE, CURRENT_STATE 

FROM SOMS_TABLE 

WHERE NAME LIKE 'AR%' 

AND NORMAL_STATE != CURRENT_STATE

ORDER BY Country ASC

Note: In MySQL you can use either != or <> and they mean the same thing.