Test Your MySQL LIKE Operator Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the LIKE keyword is used to perform pattern matching in a SELECT statement.

True False

The LIKE keyword is indeed used in MySQL to search for a specified pattern in a column.

True / False

MySQL LIKE keyword can be used without wildcards (% or _) to match patterns.

True False

The LIKE keyword must be used with wildcards (% or _) to match patterns. Without wildcards, it behaves like the = operator.

True / False

In MySQL, the wildcard character % in a LIKE pattern represents zero or more characters.

True False

The % wildcard matches zero or more characters in a pattern search.

True / False

MySQL LIKE keyword is case-sensitive by default.

True False

MySQL LIKE keyword is case-insensitive by default unless the collation of the column is set to a case-sensitive collation.

True / False

The _ wildcard in MySQL LIKE pattern represents exactly one character.

True False

The _ wildcard matches exactly one character in a pattern search.

True / False

In MySQL, you can use the LIKE keyword with numeric data types.

True False

The LIKE keyword is primarily used with string data types. Using it with numeric types is not common and can lead to errors or unexpected results.

True / False

In MySQL, the pattern LIKE 'A%' will match any string that starts with the letter 'A' and has zero or more characters following it.

True False

The pattern LIKE 'A%' matches any string starting with 'A' followed by zero or more characters.

True / False

MySQL allows combining LIKE with NOT to exclude certain patterns.

True False

You can use NOT LIKE to exclude rows that match a certain pattern.

True / False

MySQL LIKE keyword supports regular expressions for more complex pattern matching.

True False

The LIKE keyword does not support regular expressions. MySQL has a separate REGEXP operator for regular expression pattern matching.

Q10

True / False

In MySQL, using LIKE BINARY with the LIKE keyword makes the pattern match case-sensitive.

True False

The LIKE BINARY keyword in MySQL forces the LIKE pattern match to be case-sensitive.

Q11

Single Choice

Which of the following SQL statements uses the LIKE operator correctly to find all rows where the name starts with the letter 'A'?

SELECT * FROM users WHERE name = 'A%'; SELECT * FROM users WHERE name LIKE 'A%'; SELECT * FROM users WHERE name LIKE '%A';SELECT * FROM users WHERE name LIKE '_A%';

The LIKE operator is used with the pattern 'A%' to find any string that starts with 'A'. The percent sign (%) represents zero, one, or multiple characters.

Q12

Single Choice

What will be the result of the following query?

SQL Code

SELECT * FROM employees WHERE title LIKE '%Manager';

It will find all titles that end with 'Manager It will find all titles that start with 'Manager It will find all titles that contain 'Manager'It will find all titles that are exactly 'Manager'

The % before 'Manager' allows any characters to precede 'Manager'. The LIKE operator will match all rows where the title ends with 'Manager'.

Q13

Single Choice

Which of the following patterns will match any single character in the LIKE operator?

% _ *^

The underscore (_) is a wildcard in the LIKE operator that matches exactly one character.

Q14

Single Choice

Given the table products, how can you find all product names that contain the word 'book' regardless of their position in the name?

SELECT * FROM products WHERE name LIKE 'book%'; SELECT * FROM products WHERE name LIKE '%book%'; SELECT * FROM products WHERE name LIKE '_book_';SELECT * FROM products WHERE name = '%book%';

The pattern '%book%' matches any product name containing 'book', with zero or more characters before and after the word.

Q15

Single Choice

How would you write a query to find all rows in the customers table where the email field does not start with 'info'?

SELECT * FROM customers WHERE email LIKE 'info%'; SELECT * FROM customers WHERE email LIKE '%info'; SELECT * FROM customers WHERE email NOT LIKE 'info%';SELECT * FROM customers WHERE email LIKE '_info%';

The NOT LIKE 'info%' condition excludes any emails that start with 'info'.

Q16

Single Choice

In which scenario would you use the LIKE operator with a pattern like '___a%'?

To find strings that end with 'a' To find strings that contain 'a' at the third position To find strings that have exactly three characters followed by 'a'To find strings that have exactly four characters

The pattern '___a%' matches strings with exactly three characters before 'a' and any number of characters after.

Q17

Single Choice

Given the following query, what will be returned?

SQL Code

SELECT * FROM employees WHERE phone LIKE '12%3_5';

All phone numbers starting with '12' and ending with '35' All phone numbers containing '12', '3', and ending with '5' All phone numbers starting with '12', followed by any characters, and then '3' followed by any single character and ending with '5'All phone numbers exactly equal to '12%3_5'

The pattern '12%3_5' matches any phone numbers starting with '12', then any characters (%), then a '3', followed by exactly one character (_), and ending with '5'.

Q18

Single Choice

How can you search for all product codes in the inventory table where the code starts with either 'A' or 'B' and ends with the digit '3'?

SELECT * FROM inventory WHERE code LIKE 'A%3' OR code LIKE 'B%3'; SELECT * FROM inventory WHERE code LIKE 'A%B3' OR code LIKE 'B%A3'; SELECT * FROM inventory WHERE code LIKE '[AB]%3';SELECT * FROM inventory WHERE code LIKE 'A%B3' AND code LIKE 'B%A3';

The LIKE patterns 'A%3' and 'B%3' match codes starting with 'A' or 'B' and ending with '3'. The OR operator

Q19

Single Choice

You need to filter out rows where the description field contains exactly 10 characters, starting with 'Pro' and ending with 'ct'. Which query would you use?

SELECT * FROM items WHERE description LIKE 'Pro_____ct'; SELECT * FROM items WHERE description LIKE 'Pro%ct'; SELECT * FROM items WHERE description LIKE 'Pro_ct';SELECT * FROM items WHERE description LIKE 'Pro__ct';

The pattern 'Pro_____ct' matches strings that start with 'Pro', followed by exactly five characters, and end with 'ct', totaling 10 characters.

Q20

Single Choice

In the employees table, how can you find all email addresses that have exactly one character before the '@' symbol?

SELECT * FROM employees WHERE email LIKE '_%@%'; SELECT * FROM employees WHERE email LIKE '%@_'; SELECT * FROM employees WHERE email LIKE '%_@%';SELECT * FROM employees WHERE email LIKE '@_%';

The pattern '_@%' matches any email address where there is exactly one character before the '@' symbol, with any domain after it.

Q21

Multiple Choice

Which query retrieves records from the 'employees' table where the 'name' starts with the letter 'J'?

SQL Code

SELECT *
FROM employees
WHERE name LIKE 'J%';

SELECT * FROM employees WHERE name LIKE 'J%'; SELECT * FROM employees WHERE name LIKE '%J'; SELECT * FROM employees WHERE name LIKE '%J%';SELECT * FROM employees WHERE name LIKE '_J';

The LIKE operator with 'J%' is used to filter rows where the 'name' column starts with the letter 'J'.

Q22

Multiple Choice

Identify the correct SQL query that retrieves records from the 'orders' table where 'order_id' ends with '123'.

SQL Code

SELECT *
FROM orders
WHERE order_id LIKE '%123';

SELECT * FROM orders WHERE order_id LIKE '%123'; SELECT * FROM orders WHERE order_id LIKE '123%'; SELECT * FROM orders WHERE order_id LIKE '%123%';SELECT * FROM orders WHERE order_id LIKE '_123';

The LIKE operator with '%123' filters rows where the 'order_id' column ends with '123'.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where 'product_name' contains the word 'Pro'?

SQL Code

SELECT *
FROM products
WHERE product_name LIKE '%Pro%';

SELECT * FROM products WHERE product_name LIKE '%Pro%'; SELECT * FROM products WHERE product_name LIKE 'Pro%'; SELECT * FROM products WHERE product_name LIKE '%Pro';SELECT * FROM products WHERE product_name LIKE '_Pro';

The LIKE operator with '%Pro%' is used to filter rows where the 'product_name' column contains the word 'Pro'.

Q24

Multiple Choice

Determine the correct SQL query that retrieves records from the 'customers' table where the 'email' contains the domain 'example.com'.

SQL Code

SELECT *
FROM customers
WHERE email LIKE '%@example.com';

SELECT * FROM customers WHERE email LIKE '%@example.com'; SELECT * FROM customers WHERE email LIKE 'example.com%'; SELECT * FROM customers WHERE email LIKE '%example.com';SELECT * FROM customers WHERE email LIKE '_example.com';

The LIKE operator with '%@example.com' filters rows where the 'email' column contains the domain 'example.com'.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'item_code' starts with 'A' and ends with 'Z'?

SQL Code

SELECT *
FROM inventory
WHERE item_code LIKE 'A%Z';

SELECT * FROM inventory WHERE item_code LIKE 'A%Z'; SELECT * FROM inventory WHERE item_code LIKE '%A%Z'; SELECT * FROM inventory WHERE item_code LIKE 'AZ%';SELECT * FROM inventory WHERE item_code LIKE '_A%Z';

The LIKE operator with 'A%Z' is used to filter rows where the 'item_code' column starts with 'A' and ends with 'Z'.

Q26

Multiple Choice

Which query correctly retrieves records from the 'sales' table where 'sales_rep' contains the letters 'ann'?

SQL Code

SELECT *
FROM sales
WHERE sales_rep LIKE '%ann%';

SELECT * FROM sales WHERE sales_rep LIKE '%ann%'; SELECT * FROM sales WHERE sales_rep LIKE 'ann%'; SELECT * FROM sales WHERE sales_rep LIKE '%ann';SELECT * FROM sales WHERE sales_rep LIKE '_ann';

The LIKE operator with '%ann%' filters rows where the 'sales_rep' column contains the letters 'ann'.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'transactions' table where 'transaction_id' starts with 'TX' and ends with '99'.

SQL Code

SELECT *
FROM transactions
WHERE transaction_id LIKE 'TX%99';

SELECT * FROM transactions WHERE transaction_id LIKE 'TX%99'; SELECT * FROM transactions WHERE transaction_id LIKE '%TX%99'; SELECT * FROM transactions WHERE transaction_id LIKE 'TX99%';SELECT * FROM transactions WHERE transaction_id LIKE '_TX%99';

The LIKE operator with 'TX%99' is used to filter rows where the 'transaction_id' starts with 'TX' and ends with '99'.

Q28

Multiple Choice

Which SQL query retrieves records from the 'projects' table where 'project_name' starts with 'Dev'?

SQL Code

SELECT *
FROM projects
WHERE project_name LIKE 'Dev%';

SELECT * FROM projects WHERE project_name LIKE 'Dev%'; SELECT * FROM projects WHERE project_name LIKE '%Dev%'; SELECT * FROM projects WHERE project_name LIKE '%Dev';SELECT * FROM projects WHERE project_name LIKE '_Dev';

The LIKE operator with 'Dev%' is used to filter rows where the 'project_name' column starts with 'Dev'.

Q29

Multiple Choice

Identify the correct query that retrieves records from the 'clients' table where 'client_name' contains the word 'Corp'.

SQL Code

SELECT *
FROM clients
WHERE client_name LIKE '%Corp%';

SELECT * FROM clients WHERE client_name LIKE '%Corp%'; SELECT * FROM clients WHERE client_name LIKE 'Corp%'; SELECT * FROM clients WHERE client_name LIKE '%Corp';SELECT * FROM clients WHERE client_name LIKE '_Corp';

The LIKE operator with '%Corp%' is used to filter rows where the 'client_name' contains the word 'Corp'.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'students' table where 'student_id' starts with 'S' and ends with '1'?

SQL Code

SELECT *
FROM students
WHERE student_id LIKE 'S%1';

SELECT * FROM students WHERE student_id LIKE 'S%1'; SELECT * FROM students WHERE student_id LIKE '%S%1'; SELECT * FROM students WHERE student_id LIKE 'S1%';SELECT * FROM students WHERE student_id LIKE '_S%1';

The LIKE operator with 'S%1' is used to filter rows where the 'student_id' starts with 'S' and ends with '1'.

MySQL Database Quiz Questions