/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

8 votes108 views3 answers
Mysql alter table add index
SQL
0 vote122 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
14 votes134 views6 answers
Finding duplicate rows mysql
SQL
15 votes162 views5 answers
Select all tables sql
SQL
0 vote124 views1 answer
Foreign key multiple columns
SQL
0 vote147 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote126 views1 answer
Tsql delete all rows
SQL
1 vote125 views1 answer
Mariadb alter user host
SQL
-1 vote120 views1 answer
Sql add column bit
SQL
2 votes113 views1 answer
Drop table purge
SQL