/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 vote261 views1 answer
Sql select most frequent value in group
SQL
0 vote297 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote283 views1 answer
Convert rows to columns in sql server
SQL
28 votes290 views6 answers
Foreign key
SQL
0 vote283 views1 answer
Select nth row in mysql
SQL
0 vote296 views1 answer
Mysql config address
SQL
2 votes265 views2 answers
Compare date mysql
SQL
0 vote304 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote243 views1 answer
SQL server select to get sum of hours
SQL
3 votes307 views1 answer
Sql double index
SQL