Pattern matching can be done using the operator LIKE while setting the condition with pattern matching.
for eg., to display the names of all students whose name begins with letters ‘ma’, we can write the following query, SELECT name FROM STUDENT WHERE name LIKE ‘ma%’; here the character ‘%’ substitutes any number of characters in the value of the specified column. Another character substitutes only one character of the specified column.