Mysql Enum column type select all values

Question

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.

If you want all of them, do not include col in the WHERE clause at all. It won't be filtered. — Michael Berkowski
– Michael Berkowski, Commented Feb 2, 2013 at 3:11
But anway, the correct syntax would be col = 'Yes' OR col = 'No' or using IN() as col IN('Yes', 'No') — Michael Berkowski
– Michael Berkowski, Commented Feb 2, 2013 at 3:11
ah Michael,You made my day.Thanks a lot.I never thought of going via IN.I will explore that.thanks — Kiran Badi
– Kiran Badi, Commented Feb 2, 2013 at 3:13

Niet the Dark Absol · Accepted Answer · 2013-02-02 03:12:01Z

1

Use IN.

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

answered Feb 2, 2013 at 3:12

Niet the Dark Absol

326k86 gold badges480 silver badges604 bronze badges

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

1 Comment

Kiran Badi Over a year ago

I will use IN Kolink.Thanks

Collectives™ on Stack Overflow

Mysql Enum column type select all values

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related