# Mysql text with question mark

**URL:** <https://discourse.nodered.org/t/mysql-text-with-question-mark/25530>\
**Category:** General\
**Created:** [26 April 2020 08:41 UTC](https://discourse.nodered.org/t/mysql-text-with-question-mark/25530 "2020-04-26T08:41:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RogierQ](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/rogierq/32/3211_2.png) [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Post date:** [26 April 2020 08:41 UTC](https://discourse.nodered.org/t/mysql-text-with-question-mark/25530/1 "2020-04-26T08:41:00Z")

</div>

When i want to insert a text line in the database with a question mark the line is inserted into the database.

my msg.topic is like

```auto
        msg.topic = "INSERT INTO `database`(`message`) VALUES (' what is your question?')";

```

i found that the question mark is used for functions too but how can i change this?  
putting a \ in front what not the solution

---

<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:** [26 April 2020 09:39 UTC](https://discourse.nodered.org/t/mysql-text-with-question-mark/25530/2 "2020-04-26T09:39:48Z")

</div>

I don't understand what you mean. Is that sql generating an error? If so then what.

---

<div class="post-metadata">

**Author:** ![RogierQ](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/rogierq/32/3211_2.png) [@RogierQ](https://discourse.nodered.org/u/RogierQ)\
**Post date:** [26 April 2020 11:22 UTC](https://discourse.nodered.org/t/mysql-text-with-question-mark/25530/3 "2020-04-26T11:22:49Z")

</div>

sorry i tried to create a example flow but cannot reproduce it now.  
Try i tonight again

---

<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:** [25 June 2020 11:37 UTC](https://discourse.nodered.org/t/mysql-text-with-question-mark/25530/4 "2020-06-25T11:37:29Z")

</div>

Closed on 25 June 2020 11:37 UTC

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