How to retrieve data from mysql db by passing an array

Question

I have an dynamic array of id which is passed by frontend. I need to fetch data from mysql db where the tuples ids are match with the ids which i pass.

Example Id array: [6, 7, ...]

The number of items can be vary according to different requests.

SELECT expense_type, expense_category FROM expense_type WHERE expense_category_id=id1 OR expense_category_id=id2;

id1, id2 are the ids which comes from the frontend. (6,7,...)

There can be multiple ids which comes from the frontend. could i please know is there a way to fetch data from one query in such situation. Or else do i have to write multiple queries to execute?

There are two way. First you can use IN('1','2','3'). Second way you can insert these values in a temporary table and by using JOIN with that temporary table you can get result. — Santosh Vishwakarma
– Santosh Vishwakarma, Commented Nov 8, 2019 at 9:06

Jing Yu · Accepted Answer · 2019-11-08 10:00:26Z

1

You need to make query by using that multiple ids's array.

something like below

query = 'SELECT expense_type, expense_category FROM expense_type WHERE expense_category_id IN (`;
forEach(ids as id) {
 query += id + ','
}

run query..

answered Nov 8, 2019 at 10:00

Jing Yu

1,63113 silver badges18 bronze badges

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

Comments

Henrik Erstad · Accepted Answer · 2019-11-08 09:47:05Z

0

To select data based on an array of values you can use the IN-keyword. In your case it would look like this:

SELECT expense_type, expense_category
FROM expense_type
WHERE expense_category_id IN ('id1', 'id2');

edited Nov 8, 2019 at 9:47

answered Nov 8, 2019 at 9:02

Henrik Erstad

7013 gold badges12 silver badges21 bronze badges

Comments

josh Ronalds · Accepted Answer · 2019-12-02 04:16:28Z

0

you can easily use an IN. also try to use Join. so the accuracy of the query will get increase.

SELECT expense_type, expense_category
FROM expense_type
WHERE expense_category_id IN ('id1', 'id2');

answered Dec 2, 2019 at 4:16

josh Ronalds

12 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from mysql db by passing an array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related