/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

11 votes196 views4 answers
Query DISTINCT
SQL
25 votes200 views3 answers
How to use a database to see tables mysql
SQL
0 vote206 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote218 views1 answer
Safe mysql
SQL
0 vote218 views1 answer
Except in sql alchemy
SQL
1 vote227 views3 answers
Postgresql crete view
SQL
0 vote233 views1 answer
Mysql preg replace
SQL
1 vote233 views1 answer
Sql first
SQL
0 vote217 views1 answer
Like date sql server not working
SQL
1 vote197 views1 answer
Oracle sql listagg
SQL