/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 vote196 views1 answer
Netstat -tln mysql
SQL
1 vote144 views1 answer
Foreign key in oracle sql developer
SQL
1 vote189 views3 answers
SELECT * FROM
SQL
0 vote171 views1 answer
Install sql server windows 10
SQL
0 vote165 views2 answers
Sql count number of rows after group by
SQL
0 vote176 views1 answer
Sql count more than 1
SQL
0 vote173 views3 answers
Find below average salary in sql
SQL
0 vote186 views2 answers
Mysql decimal remove trailing zeros
SQL
-2 votes164 views1 answer
Modify column name in tsql
SQL
3 votes165 views1 answer
V$session not found in oracle
SQL