MySQL Node doesn't work for Parameritized Queries when there are commas

Perguntas
1

Hello -

I am running N8N self hosted version 1.56.2 with MySQL node version 2.4 (Latest) and I am having issues with the MySQL Execute node. When I run the node below, if there is a COMMA passed into the query parameter, the process only updates text before the comma.

As mentioned in this post: MySQL Node Query Parameters with commas - #5 by Lee_S

If I run the text like this: {{ $json.message.content.replace(/‘/g,"’‘").replace(/,/g,’') }} it does seem to work but drops the comma.

Any way to have a comma passed into a parametrized query correctly?

Thank you

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Try {{ Array.of( $json.message.content) }} in the query parameters field.

The docs and popups say that it wants a comma separated list, but if I remember correctly it also takes an actual array of parameter data, and that bypasses whatever code is getting tangled up with quotes and commas.

4

THAT WORKED!! Incredible. Thank you @Lee_S for your original post on this and reply to my post with an awesome answer.