Custom SQL Query
I am wondering what I am doing wrong with PM's custom query functionality. I try a simple test query directly on my Godaddy server using the WA PM database and phpmyAdmin:
SELECT * FROM pm1_users WHERE UserFirstName = "Robert"
This query works on Godaddy bringing up three "Robert's" in my database.
When I use the same query in PM's custom query field, I receive the error message"
Invalid JSON: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM pm1_users WHERE UserFirstName = \"Robert\"' at line 1"
Just in case, I tried the same test for a new column that I have added to the database. The same basic problem occurs in PM, but I am successful with the exact same query code on Godaddy.
The UserFirstName search works in PM Audience Filter, so the connection to the Godaddy database from PM is working.
Any suggestions? Thanks.