ERROR IN QUERY:

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 'AND location NOT LIKE '%:%'' at line 1

SELECT location FROM villa_location WHERE villaID = AND location NOT LIKE '%:%'