/SQL/Mysql Like(searching in the string)

Mysql Like(searching in the string)

SELECT * FROM users WHERE dept LIKE 'd%';
SELECT * FROM users WHERE dept LIKE 'dev%';
SELECT * FROM users WHERE dept LIKE '%t';
SELECT * FROM users WHERE dept LIKE '%e%';

--here '%' means any number of characters and "_" single character

Source: gist.github.com

Similar codes

0 vote262 views1 answer
Mysql error codeigniter
SQL
6 votes302 views2 answers
Mysql concatenate two columns into one
SQL
0 vote298 views1 answer
Oracle list datafiles
SQL
14 votes316 views5 answers
Set password for postgres user ubuntu
SQL
0 vote277 views1 answer
Sql server express download
SQL
0 vote315 views1 answer
Stratified sampling sql
SQL
2 votes263 views1 answer
Get first 3 letters name in sql
SQL
3 votes292 views1 answer
Oracle sleep
SQL
2 votes263 views1 answer
Select * from table where name like
SQL
2 votes305 views1 answer
Where clause for child record apex
SQL