CODEWITHSUNDEEP
mysql
Kiran Badi
Kiran Badi

Reputation: 521

Mysql Enum column type select all values

I have Enum column with 2 values in it.Yes and No, Col('Yes','No')

Now I have a one functionality where in I have use this column and pull rows with both yes and no values,

Now when I do something like col = ('Yes' OR 'No')

I dont get any records, how do I pull all rows from that has all values of enum column.I need rows that has both yes and no values.

This column is part of one of my large query so refactoring the column from enum to varchar does solve the problem ? But I am curious to know as how to select all values for enum? I tried many ways,but I always null results.

Upvotes: 0

Views: 647

Answers (1)

Niet the Dark Absol
Niet the Dark Absol

Reputation: 324650

Use IN.

SELECT blah blah blah FROM blah WHERE col IN ('Yes','No')

Upvotes: 1

Related Questions