# Mysql query dealing with set column type

**URL:** <https://forum.kirupa.com/t/mysql-query-dealing-with-set-column-type/258643>\
**Category:** Uncategorized\
**Created:** [April 25, 2008, 11:48pm UTC](https://forum.kirupa.com/t/mysql-query-dealing-with-set-column-type/258643 "2008-04-25T23:48:22Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mak\_Valley](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Mak\_Valley](https://forum.kirupa.com/u/Mak_Valley)\
**Post date:** [April 25, 2008, 11:48pm UTC](https://forum.kirupa.com/t/mysql-query-dealing-with-set-column-type/258643/1 "2008-04-25T23:48:22Z")

</div>

let’s say i have a set column in a table with ‘green’, ‘red’, ‘blue’, ‘orange’ as possible values… how would i go about selecting all of the green and blue rows in a single query? if you don’t understand my question you probably can’t help me but to dumb things down a little here’s what i want that doesn’t work:  
SELECT \* FROM colors WHERE color = ‘green’ AND color = ‘blue’