/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

5 votes328 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes308 views1 answer
Sql server find table name
SQL
0 vote307 views2 answers
Mysql to python pandas
SQL
2 votes318 views1 answer
Set column to not null mysql
SQL
0 vote311 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
1 vote323 views1 answer
Select last row from SQL Table
SQL
0 vote306 views1 answer
Oracle get running queries
SQL
0 vote341 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote327 views1 answer
Select * where id = 1,2,3
SQL
5 votes354 views1 answer
Get column name sql server
SQL