SQL Wild Card is used to search for a specific combination of characters. For example we want to see all those products from our items table where name starts with b. In this case we can't really filter data by only using WHERE, thats why we are going to use WildCard. SQL WildCard is represented by %
SYNTAX:
SELECT * FROM nameoftable WHERE column LIKE ‘%search words%’
EXAMPLE:
SELECT * FROM items WHERE itemName LIKE ‘%php%’;
Another Example:
SELECT * FROM items WHERE itemName LIKE 'b%';
DESCRIPTION:
Wild cards (%) are used to for searching something from tables. The keyword that is used with wild card(%) is LIKE. In the above mentioned example, our table name is items and we are searching for all the items where item names consist of word php. Wild cards can be used on many kinds of search pages on websites.