/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 votes375 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
17 votes360 views3 answers
Cast in sql server
SQL
0 vote386 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote360 views1 answer
Insert output identity
SQL
0 vote355 views1 answer
Mysqldump ignore table
SQL
0 vote362 views1 answer
Oracle list subpartitions
SQL
0 vote360 views2 answers
Sql query for getting details by id
SQL
0 vote336 views1 answer
Sql right characters
SQL
0 vote381 views1 answer
List in one column mysql
SQL
1 vote312 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL