I have a database emails that has crewEmails which contain email addresses. I’m trying to get all addresses that contain "comcast" in the address. Here’s the sql I’m using:
SELECT * FROM `emails` WHERE crewEmail like '%{"comcast"}%'
but this returns nothing. I absolutely have comcast email addresses in the database.
2
Answers
Maybe you should try these SQL syntax, without double quotes around comcast :
After fields and values substitutions :
No need of brackets :