CBSE Class 12 Informatics Practices Question 38 of 79

MySQL SQL Revision Tour — Question 6

Back to all questions
6
Question

Question 6

While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?

Answer

In SQL pattern matching, the underscore ('_') character matches any character, while the percent ('%') wildcard character matches any substring.