/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 vote102 views1 answer
Postgresql export output table as a csv
SQL
2 votes118 views1 answer
Mysql sysdate - 1 day
SQL
0 vote107 views1 answer
Automate mysql cli query
SQL
1 vote120 views1 answer
Mysql show queries running
SQL
2 votes119 views1 answer
Mysql time ago difference
SQL
2 votes121 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote139 views1 answer
Command to give readonly access to a postgres sql user
SQL
1 vote135 views1 answer
Nvl postgres
SQL
2 votes212 views1 answer
Sql ends with string
SQL
0 vote112 views1 answer
How to check if there is no database schema
SQL