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

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

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:

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.

1 Like

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

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