/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 vote281 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote288 views1 answer
Jenkins SQLCMD run
SQL
0 vote330 views1 answer
Find and replace query in wordpress\
SQL
0 vote304 views1 answer
SQL query to verify the size of the table
SQL
0 vote281 views1 answer
Mysql procedure between two tables
SQL
0 vote281 views1 answer
Mysql check datetime equals date
SQL
1 vote286 views2 answers
Datetrunc hour snowflake
SQL
0 vote408 views1 answer
Postgresql powershell query
SQL
0 vote277 views1 answer
Postgres full text search example
SQL
1 vote317 views1 answer
Encrypt password postgresql
SQL