# Node Red SQL Node Rejects Valid SQL Statement?
**URL:** https://discourse.nodered.org/t/node-red-sql-node-rejects-valid-sql-statement/80509
**Category:** General
**Created:** [11 August 2023 23:25 UTC](https://discourse.nodered.org/t/node-red-sql-node-rejects-valid-sql-statement/80509 "2023-08-11T23:25:45Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Nodi.Rubrum](https://discourse.nodered.org/u/Nodi.Rubrum)
#### Post date: [11 August 2023 23:25 UTC](https://discourse.nodered.org/t/node-red-sql-node-rejects-valid-sql-statement/80509/1 "2023-08-11T23:25:46Z")
This is a valid SQL statement...
SELECT Host FROM Host WHERE (`Index` = 1)
The above returns 1 record. Column is named 'Host' and table is named 'Host', and the table has a primary key on column 'Index'. I happen to be using MariaDB for the SQL back end.
However, the following returns zero results via the node-red-contrib-mysql node...
msg.topic = "SELECT Host FROM Host WHERE (`Index` = 1)";
Color me surprised!
---
### Author:  [@bakman2](https://discourse.nodered.org/u/bakman2)
#### Post date: [12 August 2023 03:06 UTC](https://discourse.nodered.org/t/node-red-sql-node-rejects-valid-sql-statement/80509/2 "2023-08-12T03:06:26Z")
> [@Nodi.Rubrum](#):
>
> However, the following returns zero results via the node-red-contrib-mysql node...
> msg.topic = "SELECT Host FROM Host WHERE (`Index` = 1)";
Could you just try:
```auto
select Host from Host where `Index`=1
```
Note that mysql/mariadb have reserved words - [index](https://mariadb.com/kb/en/reserved-words/) is one of them.
I would recommend to use more distinct wordings for tables and column namings, as it might create more problems in the future.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [11 October 2023 03:07 UTC](https://discourse.nodered.org/t/node-red-sql-node-rejects-valid-sql-statement/80509/3 "2023-10-11T03:07:27Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.