I have CUST_TBL with one of the column are EMAIL and USER_ID.
I have many records in CUST_TBL, but I only want to show the record which have specific email domain (like @gmail.com) and user with USER_ID = 'SYSADMIN1'.
I have tried this query
where user_id = 'SYSADMIN1';
Just use the
INSTR() in the
WHERE clause :
select * from corp_usr where user_id = 'SYSADMIN1' AND INSTR(email,'@gmail.com') > 0;