# Writing a MySQL query

**URL:** <https://forum.kirupa.com/t/writing-a-mysql-query/201255>\
**Category:** programming\
**Created:** [September 19, 2006, 8:55pm UTC](https://forum.kirupa.com/t/writing-a-mysql-query/201255 "2006-09-19T20:55:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![camargo](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/camargo/32/1363_2.png) [@camargo](https://forum.kirupa.com/u/camargo)\
**Post date:** [September 19, 2006, 8:55pm UTC](https://forum.kirupa.com/t/writing-a-mysql-query/201255/1 "2006-09-19T20:55:48Z")

</div>

Hello Kirupans!

I have a question about writing a particular query in MySQL. I have a data field that is a SET data type called **prodEnv** , and I have four possible values (‘ **outdoor** ’, ‘ **indoor** ’, ‘ **fixed** ’, ‘ **mobile** ’). All of my entries use more than one of those values, like maybe ‘ **indoor** ’ and ‘ **mobile** ’.

My question is, how do I write a query for all entries that contain any one of those given values, even if it has multiple values?

My current query is:

```auto
SELECT * FROM `wi4_apcpe` WHERE ` **prodEnv** ` = " **outdoor**"

```

But that will not return any entries…

Any help would be greatly appreciated! Thanks in advance.