mySQL query with IN

Hi,

I’m trying to run a simple query, with a condition that checks if the Status Code is IN a list of values.

StatusCode is a VARCHAR(20)

The query looks like this:

image1266×745 30.7 KB

There are records that meet the condition. If I run the exact same query from Heidi (the SQL database management tool that I use), the database returns them.

Wappler, however, returns nothing. This is my result:

{
“query1”:
}

conversely, if I put a NOT IN with the same list, I get all the records, even those that do not match the strings in the list.

What am I doing wrong?
Many thanks for your help,

Alex