/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

4 votes294 views1 answer
Postgresql change default value
SQL
1 vote312 views1 answer
Launch sql script from docker in mysql
SQL
0 vote290 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote316 views1 answer
Sqlalchemy order_by
SQL
4 votes318 views3 answers
Sql drop primary key
SQL
3 votes300 views1 answer
Sql multi column index performance
SQL
0 vote301 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
2 votes307 views1 answer
Change primary key sql
SQL
0 vote286 views1 answer
Postgresql subquery
SQL
0 vote345 views1 answer
Delete from table where length sql
SQL