not able to query using email id in mysql tables
<p>I am using the following table structure</p>

<pre><code>Create table SP_Rest_User
(
Client_Id varchar(50) references SP_Rest_API_Key(Client_ID) , 
User_Id varchar(255) primary key , 
password_hash varchar(255), 
is_user_active TINYINT(1),
Role varchar(50),
contact_id varchar(50) references sp_rest_contact(contact_id),Entity_Id varchar(50),
last_login_date_time datetime,
emailid varchar(100) collate armscii8_general_ci
);
</code></pre>

<p>i have added the following records </p>

<pre><code>insert into SP_Rest_User values('C00001','VINOTH','06a085d63dae33a9',1,0,'1234','1111',now(),'vinoth.m@gmail.com');
insert into SP_Rest_User values('C00002','SENTHIL','06a085d63dae33a9',1,0,'1234','1111',now(),'senthil.c@yahoo.com');
insert into SP_Rest_User values('C00002','VENKAT','06a085d63dae33a9',1,0,'1234','1111',now(),'venkat.y@gmail.com');
</code></pre>

<p>not to query the records using the email id column. getting error as record not found.</p>

<pre><code>SELECT * FROM sp_rest_user where emailid like 'venkat.y@gmail.com';
</code></pre>