/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 votes329 views2 answers
Join vs union
SQL
2 votes335 views1 answer
How to delete view in sql
SQL
3 votes368 views1 answer
Laravel paginate raw sql
SQL
2 votes337 views1 answer
How to create sql database
SQL
0 vote338 views1 answer
Postgres type equivalent to timespan c#
SQL
1 vote368 views1 answer
How to see logical reads in sql server
SQL
0 vote328 views1 answer
Php get closest location by latitude longitude
SQL
0 vote354 views1 answer
SQL check if record exist
SQL
2 votes359 views2 answers
Calculate percentage in sql
SQL
15 votes325 views2 answers
Sql order by multiple columns
SQL