Using wildCard In Structure Query Language

The most frequently used wildcard is the percent sign (%). Within a search string, % means match any number of occurrences of any character. For example, to find all products that start with the word Fish, you can issue the following SELECT statement:

SELECT prod_id, prod_name



FROM Products



WHERE prod_name LIKE 'Fish%';