/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

1 vote200 views1 answer
Insert column after column mysql
SQL
0 vote140 views1 answer
Check if record exists mysql
SQL
8 votes134 views1 answer
Oracle add month
SQL
0 vote147 views1 answer
Find and replace query in wordpress\
SQL
0 vote155 views1 answer
Mysql coonect sample code
SQL
0 vote156 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote141 views1 answer
Tsql delete all rows
SQL
2 votes188 views1 answer
Datefromparts mssql
SQL
0 vote165 views2 answers
Identity syntax in sql
SQL
0 vote104 views1 answer
Select mysql limit to 2 decimal places
SQL