Which SQL keyword can be used in conjunction with wildcards to select partial values?
A) SELECT
B) SEARCH
C) FIND
D) SUBSTRING
E) LIKE

Question

Quizplus · Accepted Answer

The keyword LIKE is used in conjunction with wildcards to select partial values. It allows us to search for a specific pattern in a column of a table. The wildcard characters that can be used with LIKE are "%" (percent sign) to represent any number of characters (including zero) and "_" (underscore) to represent a single character. For example, the query "SELECT * FROM customers WHERE last_name LIKE 'Smi%'" will select all customers whose last name starts with "Smi", such as Smith, Smithson, etc.

Which SQL Keyword Can Be Used in Conjunction with Wildcards