Mysql check if a value exists in which column

Question

I have a table which has two columns - city and country. Given a string 'X', how to know the column name which has the value 'X'?

For example, if 'X' is new york, query should return column name City and if 'X' is USA, query should return column name Country.

Viki888 · Accepted Answer · 2016-11-07 11:52:47Z

1

SELECT 
    CASE 
        WHEN city = 'X' 
            THEN 'City' 
        ELSE 'Country' 
    END column_Value 
FROM [table_Name] 
WHERE city = 'X' OR country = 'X';

You can make use of the above query.

answered Nov 7, 2016 at 11:52

Viki888

2,7742 gold badges15 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rhys Bradbury · Accepted Answer · 2016-11-07 11:53:19Z

0

select count(*) from tableName where city = "X" or country = "x"

If 0 is returned then it doesn't exist.

To check for column then:

select count(*) from tableName where city = "X" If 0 is returned then it doesn't exist in city

select count(*) from tableName where country = "X" If 0 is returned then it doesn't exist in country

edited Nov 7, 2016 at 11:53

answered Nov 7, 2016 at 11:46

Rhys Bradbury

1,71714 silver badges25 bronze badges

2 Comments

balajiprasadb Over a year ago

Updated question. Please look again. Sorry for the inconvenience.

Rhys Bradbury Over a year ago

then specify that in the question.

Collectives™ on Stack Overflow

Mysql check if a value exists in which column

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related