# mySQL query where value in field is one value or another

**URL:** <https://forum.kirupa.com/t/mysql-query-where-value-in-field-is-one-value-or-another/202469>\
**Category:** programming\
**Created:** [October 1, 2006, 6:57pm UTC](https://forum.kirupa.com/t/mysql-query-where-value-in-field-is-one-value-or-another/202469 "2006-10-01T18:57:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![natronp](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@natronp](https://forum.kirupa.com/u/natronp)\
**Post date:** [October 1, 2006, 6:57pm UTC](https://forum.kirupa.com/t/mysql-query-where-value-in-field-is-one-value-or-another/202469/1 "2006-10-01T18:57:53Z")

</div>

I have a mysql table with a field that is set to have the value “1”, “2”, “3”, or “4”.

I need to have a mysql query that does this:

SELECT \* FROM myTable WHERE myField = ‘1’ or ‘3’ ORDER BY myField2

in other words i want to grab everything from that table that has either a 1 or a 3 in that field.

no clue how to do it. thanks for any help!