/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 vote429 views1 answer
The differnece between to values in sql
SQL
0 vote318 views2 answers
Insert data into multiple tables mysql
SQL
1 vote242 views1 answer
Set mysql mode global query
SQL
0 vote252 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote245 views2 answers
Postgresql get long running queries
SQL
0 vote246 views1 answer
Mysql into outfile with headers
SQL
2 votes265 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote278 views1 answer
T sql dynamic top n query
SQL
0 vote273 views1 answer
Sql server synonym
SQL
1 vote256 views2 answers
Change table name phpmyadmin
SQL