/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

2 votes138 views1 answer
Sqlite show table indexes
SQL
3 votes137 views1 answer
Oracle rollback
SQL
0 vote141 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
3 votes149 views6 answers
DB::table('users')->get();
SQL
0 vote149 views1 answer
Second Step in installing SQL workbench
SQL
0 vote134 views1 answer
Drop all tables db2
SQL
1 vote141 views1 answer
Search for tables with name postgresql
SQL
0 vote139 views1 answer
Change role postgres
SQL
1 vote132 views1 answer
Sql restore backup query
SQL
1 vote193 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL