SQL Wildcards
The SQL WILDCARDS are used along with the SQL LIKE operator in the SELECT statement. The WILDCARDS are quite complex but are very useful in retrieving data. Consider if there’s no wildcards then we could not search in the database easily. You would have to enter each and every character to match the required result. So, for easier search, SQL WILIDCARDS comes to rescue.
Now what wildcards really are? They are set of characters which lets the DBMS to know that what and how to look for the query.
Some Important Wildcards