# How to get single record from select query..?

**URL:** <https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000>\
**Category:** General\
**Created:** [25 December 2020 09:46 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000 "2020-12-25T09:46:08Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ptwtech](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@Ptwtech](https://discourse.nodered.org/u/Ptwtech)\
**Post date:** [25 December 2020 09:46 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/1 "2020-12-25T09:46:08Z")

</div>

Hello All,

I want to get single record from select query.... i am getting output in object..?  
I'm writing query in function like this

msg.topic= "select body from test limit 1;"  
return msg;

i am getting this output  
array[1]  
0: object  
body: "SI,310720,054307,1831.9042,N,07356.2427,E,61.01,0,1,0.0,A"

i want value of body in variable ... because i have to pass that value in another query.  
Thanks

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [25 December 2020 09:51 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/2 "2020-12-25T09:51:14Z")

</div>

What node are ou using? Did you check the node's options to see if it can return one msg per record?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [25 December 2020 09:51 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/3 "2020-12-25T09:51:44Z")

</div>

There’s a great page in the docs that will explain how to use the debug panel to find the right path to any data item.

> **[Working with messages : Node-RED](https://nodered.org/docs/user-guide/messages)**

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [25 December 2020 09:54 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/4 "2020-12-25T09:54:45Z")

</div>

Or move the item to where you want it using a change node.

```auto
[{"id":"7d33b77c.2dfdd8","type":"inject","z":"8d22ae29.7df6d","name":"","props":[{"p":"payload[0]","v":"{\"body\": \"SI,310720,054307,1831.9042,N,07356.2427,E,61.01,0,1,0.0,A\"}","vt":"json"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","x":140,"y":2020,"wires":[["53535fbb.5abe6"]]},{"id":"53535fbb.5abe6","type":"change","z":"8d22ae29.7df6d","name":"","rules":[{"t":"move","p":"payload[0].body","pt":"msg","to":"payload","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":340,"y":2020,"wires":[["2a105b6e.c8af14"]]},{"id":"2a105b6e.c8af14","type":"debug","z":"8d22ae29.7df6d","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":570,"y":2020,"wires":[]}]

```

---

<div class="post-metadata">

**Author:** ![Ptwtech](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@Ptwtech](https://discourse.nodered.org/u/Ptwtech)\
**Post date:** [25 December 2020 10:04 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/5 "2020-12-25T10:04:11Z")

</div>

PFA  
I am using function and mysql node .  
in function node i write select query.

msg.topic= "select body from test limit 1;"  
return msg;

 ![Sql_NodeRed](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/e/4e6a7b46285a29379c7b8bce1b3eb81d101ee663.jpeg)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [25 December 2020 11:10 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/6 "2020-12-25T11:10:47Z")

</div>

feed it into a `split` node

---

<div class="post-metadata">

**Author:** ![Ptwtech](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@Ptwtech](https://discourse.nodered.org/u/Ptwtech)\
**Post date:** [25 December 2020 12:23 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/7 "2020-12-25T12:23:58Z")

</div>

how..if possible can you give example..?

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [25 December 2020 13:31 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/8 "2020-12-25T13:31:33Z")

</div>

You've already been given an example by @E1cid for using a Change node to move the property you want to where you need it. Import that flow and see what it does.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 February 2021 13:31 UTC](https://discourse.nodered.org/t/how-to-get-single-record-from-select-query/38000/9 "2021-02-23T13:31:36Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.