/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 vote158 views1 answer
Mysql root permission denied lost
SQL
5 votes176 views1 answer
Oracle create table comment
SQL
16 votes192 views3 answers
Order by sql query
SQL
0 vote168 views1 answer
Mysql remove bad character from all fields
SQL
1 vote153 views2 answers
Oracle replace
SQL
6 votes152 views6 answers
Count mysql
SQL
0 vote150 views1 answer
Min and max salary and name in sql
SQL
4 votes145 views1 answer
Postgresql show current database
SQL
1 vote183 views1 answer
Postgresql float 2 decimal places
SQL
0 vote150 views1 answer
How to output a different column name in mysql
SQL