/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

7 votes168 views1 answer
Forge server hosting
SQL
0 vote169 views1 answer
Get first name and last name from full name string in SQL
SQL
3 votes189 views1 answer
Oracle rollback
SQL
0 vote188 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
13 votes188 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote164 views1 answer
Php delete database
SQL
0 vote178 views1 answer
Get first monday of month sql
SQL
0 vote199 views1 answer
Oracle webcenter content search enginer
SQL
0 vote184 views2 answers
Sql use not in
SQL
2 votes177 views1 answer
Sql create database
SQL