/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

5 votes204 views3 answers
Oracle first day of last year
SQL
0 vote153 views1 answer
Now() -1 mysql
SQL
0 vote211 views1 answer
How much space does sql server take per row
SQL
0 vote205 views1 answer
Drop-toys-table
SQL
3 votes222 views3 answers
Raw select laravel
SQL
2 votes197 views1 answer
How to find table table in stored procedure sql server
SQL
3 votes197 views2 answers
Df to sql pandas sql achemy
SQL
0 vote230 views1 answer
Mysql case when on date
SQL
0 vote240 views1 answer
Stop and start mysql
SQL
0 vote194 views2 answers
Postgres default user
SQL