Why does the same SQL query return different results in JS and phpMyAdmin?

Question

MySQL

I have a db. One of the tables stores json arrays with user ids in the form of strings ('[1,2,3]')
When I make such a request through phpMyAdmin's sql console

SELECT * FROM conversations WHERE members REGEXP '(\\[|\,)+(1)(\\]|\,)+'

then the correct result is given (all arrays where there is id 1)
But when I make the same request from the node js server using the npm package mysql2 (2.2.5), then the wrong result is given (generally all arrays)

Request with node js:

pool.execute("SELECT * FROM conversations WHERE members REGEXP '(\\[|\,)+(1)(\\]|\,)+'")

What was it and how to fix it?

Answer 1

Maybe it's the lack of escaping characters in a string expression in js https://learn.javascript.ru/string#spetssimvoly