# Mysql search term in valid

**URL:** <https://discourse.nodered.org/t/mysql-search-term-in-valid/84821>\
**Category:** General\
**Created:** [23 January 2024 07:47 UTC](https://discourse.nodered.org/t/mysql-search-term-in-valid/84821 "2024-01-23T07:47:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![HenryTrang](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henrytrang/32/81582_2.png) [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Post date:** [23 January 2024 07:47 UTC](https://discourse.nodered.org/t/mysql-search-term-in-valid/84821/1 "2024-01-23T07:47:57Z")

</div>

hello all i search for today's data but mysql ignore the term. what can i do. this is the sql i wrote, it work on mysql, but it fail in red-node.

select \* from records where create\_time \>CURDATE() AND create\_time \< CURDATE()+INTERVAL 1 DAY

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [23 January 2024 14:52 UTC](https://discourse.nodered.org/t/mysql-search-term-in-valid/84821/2 "2024-01-23T14:52:19Z")

</div>

Exactly what error are you seeing?

Assuming that you are sending the query in the message please attach a debug node showing what is going _into_ the mysql node, and another showing what is coming _out_ of the mysql node. Set both debug nodes to Output Complete Message and show us what you see. Make sure to expand both debug nodes in the debug pane enough that we can see what is there.

Which mysql node have you installed? Probably node-red-contrib-something.

---

<div class="post-metadata">

**Author:** ![HenryTrang](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/henrytrang/32/81582_2.png) [@HenryTrang](https://discourse.nodered.org/u/HenryTrang)\
**Post date:** [26 January 2024 06:24 UTC](https://discourse.nodered.org/t/mysql-search-term-in-valid/84821/3 "2024-01-26T06:24:02Z")

</div>

sorry Colin. my silly mistake. it is cache. i reboot my computer and it work. thanks for your reply. so appreciated.

---

<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:** [9 February 2024 06:24 UTC](https://discourse.nodered.org/t/mysql-search-term-in-valid/84821/4 "2024-02-09T06:24:29Z")

</div>

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