/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

6 votes141 views3 answers
Oracle all dates between two dates
SQL
0 vote138 views1 answer
Can we rollback in sql
SQL
22 votes125 views2 answers
Mysql show all tables
SQL
1 vote140 views1 answer
SQLite order random
SQL
36 votes156 views3 answers
Add column in mysq
SQL
1 vote133 views1 answer
Oracle split string
SQL
0 vote101 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
4 votes143 views2 answers
Oracle drop job
SQL
4 votes151 views1 answer
Adding data to table in sql python
SQL
0 vote137 views1 answer
What is the difference between now() and current_date()?
SQL