/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

0 vote196 views1 answer
Test sql query
SQL
0 vote223 views1 answer
Sql server rtrim everything after character
SQL
1 vote176 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote174 views2 answers
How to save result of sqlite query in a table
SQL
0 vote190 views1 answer
MySql get primary keys of table
SQL
0 vote181 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote154 views1 answer
How to create an SQL save method in ruby
SQL
7 votes187 views1 answer
Query delete duplicates
SQL
0 vote154 views1 answer
Sub blocks in sql
SQL
1 vote180 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL