/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 vote324 views1 answer
Mysql date equals to current_date plus days
SQL
2 votes285 views1 answer
Anonymous block plsql
SQL
0 vote298 views1 answer
Sql select most frequent value in column
SQL
1 vote304 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote317 views1 answer
Gcloud sql instance list
SQL
0 vote284 views1 answer
Oracle last character of string
SQL
0 vote320 views1 answer
Sql express database size limit
SQL
0 vote305 views1 answer
Sql tabelle erstellen
SQL
0 vote308 views1 answer
How to list function in psql
SQL
0 vote310 views1 answer
Postrgres trunc
SQL