/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 vote299 views1 answer
How to fetch data from database in sql
SQL
0 vote265 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
6 votes267 views1 answer
T-sql test if table exists
SQL
0 vote276 views2 answers
Unique key
SQL
0 vote277 views1 answer
Sql show table name in result
SQL
3 votes256 views1 answer
How to remove characters from string in mysql
SQL
0 vote265 views1 answer
Mysql conf.d exampel
SQL
0 vote270 views1 answer
What is top n result in sql
SQL
9 votes275 views1 answer
Alter table column change data type to text mysql
SQL
0 vote249 views1 answer
How to get all values in a table mysql in c#
SQL