How do you perform pattern matching in SQL using wildcards?

Question Explain

This question checks proficiency in string manipulation and searching capabilities within SQL.