Use of % Wildcard :
One of the wild card named percentage sign wild card is used to disply
The most commonly used wildcard is the percent sign (%).This character is used with the search string, % specifies that match any number of occurrences of any character. For example,A table named Products and contains too many rows and I need to find all the name of products that start with the word MAN.
To find that required product,you can use the following SELECT statement:
Code:
SELECT pd_id, pd_name
FROM products
WHERE prod_name LIKE 'MAN%';
Bookmarks