# mysql\_query() question

**URL:** <https://forum.kirupa.com/t/mysql-query-question/252782>\
**Category:** programming\
**Created:** [February 23, 2008, 2:02pm UTC](https://forum.kirupa.com/t/mysql-query-question/252782 "2008-02-23T14:02:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![tanel96](https://avatars.discourse-cdn.com/v4/letter/t/5fc32e/32.png) [@tanel96](https://forum.kirupa.com/u/tanel96)\
**Post date:** [February 23, 2008, 2:02pm UTC](https://forum.kirupa.com/t/mysql-query-question/252782/1 "2008-02-23T14:02:42Z")

</div>

I have an array called rightStuff that houses a bunch of numbers, like so:

```php
$rightStuff = ("1","3","5");

```

Now, i’m trying to write a mysql query that would only picks out rows, where its ‘engine’ field value is found in the array…

```php
 
mysql_query("SELECT * FROM table WHERE engine = ... ");

```

How should I achieve something like that ?