/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

1 vote209 views1 answer
Setval pgsql
SQL
0 vote208 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote219 views1 answer
Sql with example
SQL
0 vote200 views1 answer
Inner joint
SQL
0 vote211 views1 answer
Python connect microsoft sql server
SQL
0 vote182 views1 answer
Sort by last two number sql
SQL
1 vote205 views1 answer
Postgres set column equal to another
SQL
0 vote292 views2 answers
Sqlalchemy default value for column
SQL
0 vote217 views1 answer
Sql select column name like from multiple tables
SQL
4 votes206 views2 answers
Sql table
SQL