/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 vote181 views1 answer
Sql count null as 0
SQL
-1 vote221 views2 answers
Full join sql
SQL
0 vote189 views2 answers
Mysql to python pandas
SQL
3 votes225 views2 answers
Search text in all sql server stored procedure
SQL
0 vote201 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote193 views1 answer
Install sql server windows 10
SQL
0 vote181 views1 answer
Mysql 1 hour ago
SQL
8 votes187 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote206 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote258 views1 answer
How to get number of months between 2 dates sql server
SQL