/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 vote135 views1 answer
Postgress append string in select
SQL
10 votes130 views2 answers
Tsql merge example
SQL
-1 vote135 views2 answers
First letter capital in mysql query
SQL
0 vote137 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote139 views1 answer
Original Query
SQL
0 vote119 views1 answer
Mysql show category once count how many products
SQL
42 votes201 views6 answers
Install beautifulsoup
SQL
0 vote265 views1 answer
Sql change a colum to unique
SQL
0 vote121 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote128 views1 answer
Mysql where in keep order
SQL