/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

6 votes203 views1 answer
SQL insert all columns
SQL
0 vote151 views1 answer
Big query add table rows to another table
SQL
0 vote185 views1 answer
Mysql add to value
SQL
1 vote185 views1 answer
Create table tablename as select * from tablename
SQL
6 votes230 views2 answers
Insert into select mysql
SQL
0 vote187 views1 answer
Mysql record group by created date count
SQL
0 vote209 views1 answer
Select new table sql
SQL
0 vote201 views1 answer
Oracle calculate statistics on partition
SQL
1 vote198 views1 answer
How to group by month using sql server
SQL
7 votes313 views2 answers
Mysql default value
SQL