...

Database Managment - MySql

Back to Course

Lesson Description


Lession - #1316 SQL Wildcards


A mysql like wild card character is utilized to substitute at least one characters in a string. wildcard characters are utilized with the LIKE operator. The LIKE operator is utilized in a WHERE clause to look for a specified pattern in a column.



Let's see an example



SELECT * FROM EMPLOYEE
WHERE name LIKE 'a%';


SELECT * FROM EMPLOYEE
WHERE dept LIKE '___es';

Output


Try it here
mysql interview questions for experienced mysql basic interview questions mysql questions mysql query interview questions mysql interview questionsmysql interview question