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

[n8n_rookie]

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

[n8n]

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:

[Lee_S]

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.

[n8n_rookie]

@Lee_S

{{ Array.of( $json.message.content) }}

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