/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 vote335 views1 answer
Sql server remove enter from string
SQL
0 vote358 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote310 views1 answer
Postgres float to int
SQL
0 vote351 views1 answer
Mariadb datetime change to microseconds
SQL
1 vote340 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
17 votes307 views2 answers
How to assign date field for table in mysql
SQL
0 vote334 views1 answer
Qt qsql check if table exist
SQL
0 vote323 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote330 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote360 views1 answer
How to install sql in anaconda
SQL