/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

3 votes255 views3 answers
1396(hy00) mysql error
SQL
0 vote185 views1 answer
Print sum of values sql
SQL
2 votes224 views1 answer
Creating a view SQL
SQL
0 vote252 views2 answers
Greater than sql server
SQL
5 votes245 views1 answer
How to get all table names in sql query
SQL
0 vote241 views1 answer
Insert data from stored procedure into table
SQL
0 vote227 views1 answer
Sql remove first character from string
SQL
1 vote255 views1 answer
Default
SQL
0 vote218 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
10 votes247 views2 answers
Mysql remove only_full_group_by permanently
SQL