/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 vote110 views1 answer
Sqlalchemy get ids
SQL
4 votes89 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
3 votes101 views1 answer
Postgresql if null then 0
SQL
19 votes102 views2 answers
Mysql tinyint max value
SQL
0 vote96 views1 answer
Oracle create package body
SQL
20 votes103 views4 answers
Sqlite create table if not exists
SQL
1 vote106 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
1 vote151 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote111 views1 answer
Trigger vérifier stock
SQL
0 vote142 views1 answer
Sql pivot table
SQL