/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 vote128 views1 answer
Postgresql alter column nullable
SQL
1 vote137 views1 answer
Mysql find most common value
SQL
4 votes124 views1 answer
Check database name postgresql
SQL
123 votes339 views5 answers
Sql where contains
SQL
1 vote209 views1 answer
Create new table from old table with data
SQL
1 vote140 views1 answer
Quit mysql
SQL
2 votes154 views1 answer
Oracle kill session by sql_id
SQL
-1 vote130 views5 answers
Not in sql
SQL
0 vote142 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote139 views1 answer
T sql check active deadlock
SQL