/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 votes122 views2 answers
Postgresql insert select
SQL
0 vote102 views1 answer
How to find unique key in sql
SQL
0 vote112 views1 answer
Mysql select inside sum
SQL
1 vote108 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote83 views1 answer
Get max salary from each department sql
SQL
5 votes129 views2 answers
Get columns number sql
SQL
3 votes117 views2 answers
How to list columns for particular tables in postgresql
SQL
2 votes63 views1 answer
Sql select min value from multiple columns
SQL
1 vote111 views2 answers
Pad zero sql server
SQL
5 votes137 views1 answer
Migrate sql table another database
SQL