Answers for "mysql like string search"

SQL
0

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
Posted by: Guest on July-23-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language