Answer: LIKE
SELECT * FROM student WHERE name LIKE '%Abhisek%'
The above command will retrieve records with name Abhisek in the name column.
We can use different wildcard characters to specify the condition.
Asked In: Many Interviews |
Alert Moderator