/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 vote232 views2 answers
Postgresql display subquery as json
SQL
0 vote237 views1 answer
Mssql now diff 90 day
SQL
1 vote251 views1 answer
Postgresql not in
SQL
0 vote249 views1 answer
Change database name psql 8
SQL
0 vote245 views1 answer
Postgres select from values
SQL
5 votes230 views3 answers
String concatenation sql server
SQL
1 vote233 views1 answer
Does insert into overwrite sql
SQL
6 votes229 views1 answer
Oracle desc table primary key
SQL
1 vote256 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote239 views1 answer
Create database store
SQL