/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 vote320 views1 answer
Import sql file mysql commadn line
SQL
0 vote328 views1 answer
Sql replace id with name from another table
SQL
0 vote269 views1 answer
Testing sql queries
SQL
0 vote292 views1 answer
Mysql timeout 30 seconds
SQL
0 vote300 views1 answer
How to export table data from mysql table in sql format
SQL
1 vote329 views1 answer
Operator does not exist: integer = text
SQL
3 votes318 views1 answer
Oracle user quota on tablespace
SQL
1 vote352 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote312 views1 answer
Sql how to display two atributes as one in sql
SQL
19 votes326 views6 answers
Sql create table
SQL