/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

2 votes147 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote127 views1 answer
Sql drop default
SQL
2 votes132 views1 answer
Mysql application.properties spring boot
SQL
0 vote87 views1 answer
Mysql workbench search all tables
SQL
1 vote123 views1 answer
Get rows affected mysql python
SQL
0 vote123 views4 answers
Mysql on kubernetes
SQL
11 votes197 views2 answers
Sql between date range
SQL
0 vote131 views1 answer
Virtuoso sql query tutorial
SQL
1 vote124 views1 answer
Mysql show data from table
SQL
0 vote126 views1 answer
Drop-toys-table
SQL