/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

1 vote208 views1 answer
Sql select row with max date
SQL
0 vote188 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
1 vote197 views1 answer
Postgresql substring last
SQL
6 votes199 views2 answers
Stored procedure to delete data from table in mysql
SQL
4 votes203 views3 answers
How to describe a table in sqlite3
SQL
1 vote307 views1 answer
Python clean sql string
SQL
7 votes181 views1 answer
Safe mode mysql
SQL
0 vote190 views2 answers
Mysql on update current_timestamp
SQL
0 vote202 views1 answer
Oracle synonym procedure dblink
SQL
0 vote205 views2 answers
Identity column in sql server
SQL