# Mysql - multiple queries in one line
**URL:** https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655
**Category:** General
**Created:** [3 June 2021 12:58 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655 "2021-06-03T12:58:13Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@chuckyro](https://discourse.nodered.org/u/chuckyro)
#### Post date: [3 June 2021 12:58 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/1 "2021-06-03T12:58:13Z")
hi,
simple question... is it possible to send to MySQL ... 2,3.. queries in one single line (topic) ?
eg:
msg.topic = "select 1 ; select 2; select 3;" // .. of course here I'll have something more complex...
if I send that, I receive in payload:
array[3]
0: undefined
1: undefined
2: undefined
Thanks,
D.
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [3 June 2021 13:25 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/2 "2021-06-03T13:25:10Z")
I don't believe it is possible as you have written it. What do you want to get back? Each select would return an array of records, so are you hoping to get an array of three (one for each select) where each element is itself the array recordset from the select?
---
### Author:  [@chuckyro](https://discourse.nodered.org/u/chuckyro)
#### Post date: [3 June 2021 14:09 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/3 "2021-06-03T14:09:50Z")
kind of .. I would expect in a complex example ..to receive 2-3 arrays of different length and values, of course.
another example ..one query/array with device\_details... and one query/array with device\_type\_details.
I could do that in 2-3 steps (in cascade) ..easily...but I just want one round to DB ! not 2 (or 3)
---
### Author:  [@Colin](https://discourse.nodered.org/u/Colin)
#### Post date: [3 June 2021 14:26 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/4 "2021-06-03T14:26:35Z")
No, I don't think you can do that. In fact I don't think the DB can do that in one go can it?
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [3 June 2021 15:24 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/5 "2021-06-03T15:24:35Z")
You haven’t shown us rather actual queries - ie are they of the same table - but you should look up ‘MySQL or’ and see if that would work for you
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [2 August 2021 15:25 UTC](https://discourse.nodered.org/t/mysql-multiple-queries-in-one-line/46655/6 "2021-08-02T15:25:17Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.