/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 vote162 views1 answer
Mysql month name extract
SQL
5 votes138 views1 answer
Mysql add user with all privileges
SQL
0 vote113 views0 answer
SQL
0 vote183 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
11 votes152 views2 answers
Insert current date sql
SQL
0 vote170 views1 answer
Create function in microsoft sql server
SQL
9 votes203 views6 answers
Replace sql
SQL
1 vote200 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote157 views1 answer
Less mysql display
SQL
0 vote303 views1 answer
Postrgesql concat 2 columns divided by ;
SQL