Wappler Version : 3.9.1
Operating System : Mac OS X
Server Model: Node
Database Type: MySQL
Hosting Type: Docker
Expected behavior
be able to run a IN SQL query:
WHERE id IN (1,6)
Actual behavior
What actually happens?
Tried it using the paged query and as a custom query:
In the paged query it creates
WHERE id in ‘1,6’
As a custom query it creates it wraps the param in single quotes
WHERE id in (‘1,6’)
How to reproduce
Try and run an ‘in’ query with any of the MySQL functions