/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

0 vote340 views1 answer
Get first monday of month sql
SQL
2 votes360 views1 answer
SQL IF ELSE
SQL
0 vote384 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote357 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote355 views1 answer
Heidisql check how much space a row
SQL
0 vote349 views1 answer
Mysql cdn link
SQL
1 vote339 views2 answers
Sql multiline comment
SQL
0 vote394 views1 answer
Sql sort ages
SQL
1 vote370 views1 answer
Oracle previous year
SQL
7 votes370 views1 answer
Oracle alter sequence restart start with
SQL