Wildcards – Special characters used to mach parts of a value.
Search Pattern - A search condition made up of literal text, wildcards characters, or any combination of the two.
The Percent Sing (%) Wildcard
it means to mach any number of occurrences of any character. So we going to find all products that starts with the word Rabbit
SELECT prod_id, prod_name
WHERE prod_name LIKE ‘Rabbit%’;
So the DBMS retrieved all…