/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

6 votes363 views4 answers
Mysql group by date
SQL
0 vote345 views1 answer
Java sql connection
SQL
2 votes389 views2 answers
Set value to null sql
SQL
-1 vote329 views1 answer
Mysql delete duplicate rows except one
SQL
1 vote323 views2 answers
Difference between in and between in sql
SQL
0 vote350 views1 answer
Cross apply top for each row t1
SQL
9 votes341 views6 answers
Sql add column with default value
SQL
3 votes316 views2 answers
Mysql time
SQL
-1 vote335 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote323 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL