COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
#
|
|
$
|
|
[ ]
|
|
____
|
Detailed explanation-1: -MySQL Wildcards A wildcard character is used to substitute one or more characters in a string. Wildcard characters are used with the LIKE operator. The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.
Detailed explanation-2: -SQL supports two wildcard operators in conjunction with the LIKE operator which are explained in detail in the following table. Sr.No. Matches one or more characters. Note − MS Access uses the asterisk (*) wildcard character instead of the percent sign (%) wildcard character.
Detailed explanation-3: -Matches any single character within the specified range or set that is specified between brackets [ ] . These wildcard characters can be used in string comparisons that involve pattern matching, such as LIKE and PATINDEX .