jee5LUU6

1SELECT * FROM `Careers` WHERE `Email` LIKE '%something%' and
2
3SELECT * FROM `Careers` WHERE `Email` LIKE '%gmail.com%' and
4
5SELECT * FROM `Careers` WHERE `Email` LIKE '%@%'.
6	
7SELECT * FROM `Careers` WHERE `Email` LIKE 'something@gmail.com' and
8
9SELECT * FROM `Careers` WHERE `Email` LIKE '%something@gmail.com%' and
10
11SELECT * FROM `Careers` WHERE `Email` LIKE '%@gmail.com%'
12
13SELECT * FROM `Careers` WHERE `Email` LIKE '%something%gmail.com'
14	
15SELECT * FROM table1 WHERE `Email` = 'something@gmail.com' -- No need of LIKE operator
16
17SELECT * FROM table1 WHERE `Email` = 'something@gmail.com' -- No need of LIKE operator
18
19SELECT * FROM table1 WHERE `Email` LIKE '%@gmail.com' -- search before string
20
21SELECT * FROM table1 WHERE `Email` LIKE 'something?gmail.com' -- search a single char