Answers for "mysql select where string like"

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