/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

3 votes408 views1 answer
Where id is in list sql
SQL
0 vote361 views1 answer
Mysql get last 2 month data
SQL
0 vote419 views1 answer
Mariadb change column type
SQL
0 vote361 views1 answer
Rows, INSERT INTO, Returning
SQL
-1 vote342 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote330 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote367 views1 answer
Postgresql port 5432 not open
SQL
0 vote384 views2 answers
Postgres isnull
SQL
16 votes390 views6 answers
Mysql find duplicates in same table
SQL
0 vote330 views1 answer
How to get all values in a table mysql in c#
SQL