/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

3 votes200 views1 answer
Oracle undo tablespace schema
SQL
0 vote139 views1 answer
Oracle function select into
SQL
7 votes173 views3 answers
Postgresql dump and restore db
SQL
3 votes189 views1 answer
Oracle revoke
SQL
0 vote195 views1 answer
Creating h2 database in relative directory eclopse
SQL
0 vote258 views1 answer
Generate sql from specific migration ef core
SQL
0 vote164 views1 answer
Oracle DROP PROGRAM
SQL
0 vote974 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote191 views1 answer
Exectuer myssql .sql
SQL
0 vote185 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL