[Vtigercrm-developers] Web Services Javascript

Alan Lord alanslists at gmail.com
Wed May 20 09:10:19 GMT 2015


On 20/05/15 08:13, Christophe Humbert wrote:
> "SELECT * FROM Contacts WHERE email like'%@gmail.com'";

two things:

1. You have no space between like and the '%@gmail.com'
2. Have you tried without the "@" symbol - it might be being treated as 
a special character..., e.g.

 > "SELECT * FROM Contacts WHERE email LIKE '%gmail.com'";




More information about the vtigercrm-developers mailing list