MySQL go through array of values and return every row with match

Question

Say I have an array with IDs:

values = [0, 43, 5]

Now I want to go through my table "tbl_EVENTS" and return every row where EVENTID = 0, 43, or 5.

Every ID will only appear once. So I could technically do three different queries.

I am working with a javascript frameworks that builds an SQL string in the end, so I could wrap this into a for loop if necessary.

Rakesh K · Accepted Answer · 2021-08-19 10:51:54Z

2

This what you are looking for:

If your values = [0, 43, 5] an array then, we can use join method with template literals.

const values = [0, 43, 5];
`SELECT * FROM tbl_EVENTS WHERE EVENTID IN(${values.join(',')})`

edited Aug 19, 2021 at 10:51

answered Aug 19, 2021 at 10:49

Rakesh K

1,3301 gold badge18 silver badges44 bronze badges

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

7 Comments

innom Over a year ago

Thank you. But this isnt dynamic enough. I dont know the arrays length at first...

Rakesh K Over a year ago

Updated my answer. No need to know the length of the array.

Rakesh K Over a year ago

We are using template literals ( backticks ) here to concatenate the query and our spread.

innom Over a year ago

Here is my syntax: var arrObject = new Array(); for (var i = 0; i < eventIdResults.length; i++) { arrObject.push(eventIdResults.itemAtIndex(i).tblEventID) } var string = "SELECT * FROM 10561_12865_tblEvents WHERE tblEventID IN(${arrObject.join(',')})" var res = K.query(string,[]); But it fails. Stating that I have an error in my syntax "near arrObject.join(',')"

Rakesh K Over a year ago

` "SELECT * FROM 10561_12865_tblEvents WHERE tblEventID IN(${arrObject.join(',')})"` Wrap this in backticks not double quotes

|

Collectives™ on Stack Overflow

MySQL go through array of values and return every row with match

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related