/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

1 vote222 views1 answer
Mysql strict_trans_tables
SQL
2 votes215 views1 answer
Update with join sql server
SQL
0 vote208 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote217 views1 answer
Xampp increame mysql speed
SQL
0 vote233 views2 answers
Postgresql gset
SQL
0 vote219 views1 answer
Print hello world in plsql
SQL
11 votes211 views2 answers
Import sql file laravel cmd
SQL
1 vote204 views1 answer
Postgres get timestamp
SQL
2 votes208 views6 answers
In in sql
SQL
5 votes203 views1 answer
Mysql get last day of month
SQL