Test Your MySQL NOT LIKE Operator Knowledge with Our SQL Quiz

Progress

True / False

In MySQL, the NOT LIKE operator is used to search for a specified pattern in a column.

True False

The NOT LIKE operator is used to search for values that do not match a specified pattern.

True / False

MySQL's NOT LIKE can be used to exclude rows where a column value contains a specific substring.

True False

The NOT LIKE operator in MySQL excludes rows where the column value contains the specified pattern.

True / False

MySQL's NOT LIKE operator can only be used with numeric data types.

True False

The NOT LIKE operator in MySQL is used with string data types to filter out rows that do not match the specified pattern.

True / False

In MySQL, the NOT LIKE operator is case-sensitive by default.

True False

By default, the NOT LIKE operator in MySQL is case-sensitive, depending on the collation of the column being searched.

True / False

The MySQL query SELECT * FROM employees WHERE name NOT LIKE '%John%'; will return rows where the name contains the substring 'John'.

True False

The query will return rows where the name does not contain the substring 'John'.

True / False

Using NOT LIKE 'A%' in a MySQL query will exclude rows where the column values start with the letter 'A'.

True False

The pattern 'A%' matches any value that starts with 'A', and NOT LIKE 'A%' excludes those rows.

True / False

MySQL allows the use of multiple NOT LIKE conditions combined with the AND operator to exclude rows that match multiple patterns.

True False

Multiple NOT LIKE conditions can be combined with AND to exclude rows that match any of the specified patterns.

True / False

The MySQL query SELECT * FROM products WHERE description NOT LIKE '%cheap%' AND description NOT LIKE '%discount%'; will return rows where the description contains either 'cheap' or 'discount'.

True False

The query will return rows where the description does not contain 'cheap' or 'discount'.

True / False

MySQL's NOT LIKE operator can be used in a HAVING clause to filter out groups that do not match a specific pattern

True False

The NOT LIKE operator can be used in the HAVING clause to filter out groups based on aggregated column values that do not match a pattern.

Q10

True / False

In MySQL, SELECT * FROM orders WHERE order_status NOT LIKE 'completed%'; will return all rows where the order_status column does not start with the word 'completed'.

True False

The NOT LIKE 'completed%' condition filters out rows where the order_status starts with 'completed', returning only those rows where it does not.

Q11

Single Choice

Which of the following SQL statements correctly uses the NOT LIKE operator to find records where the name column does not start with the letter 'A'?

SELECT * FROM employees WHERE name NOT LIKE '%A'; SELECT * FROM employees WHERE name NOT LIKE 'A%'; SELECT * FROM employees WHERE name NOT LIKE '_A%';SELECT * FROM employees WHERE name NOT LIKE '%A%';

The NOT LIKE 'A%' pattern matches all records where the name does not start with 'A'.

Q12

Single Choice

Which of the following will return rows where the email column does not contain a '.com' domain?

SELECT * FROM users WHERE email NOT LIKE '%.com'; SELECT * FROM users WHERE email NOT LIKE '%.com%'; SELECT * FROM users WHERE email NOT LIKE '%@%.com';SELECT * FROM users WHERE email NOT LIKE '%.com_';

The NOT LIKE '%.com%' pattern filters out rows where the email does not contain '.com'.

Q13

Single Choice

What will the following SQL query return?

SQL Code

SELECT * FROM products WHERE product_name NOT LIKE '%phone%';

All products with product_name containing 'phone' All products without 'phone' in product_name Only products with product_name ending with 'phone'No products

The NOT LIKE '%phone%' pattern excludes any product_name containing 'phone'.

Q14

Single Choice

How would you modify the following SQL statement to return rows where the address column does not start with '123'?

SQL Code

SELECT * FROM customers WHERE address NOT LIKE '123%';

Change NOT LIKE '123%' to LIKE '123%' Change NOT LIKE '123%' to LIKE '%123%' Change NOT LIKE '123%' to NOT LIKE '%123'The statement is correct and needs no modification

The NOT LIKE '123%' pattern is already correctly filtering rows where the address does not start with '123'.

Q15

Single Choice

In the following SQL statement, which pattern will correctly exclude records where username contains any digits?

SQL Code

SELECT * FROM users WHERE username NOT LIKE '______';

username NOT LIKE '%[0-9]%' username NOT LIKE '%[0-9]%'; username NOT LIKE '%[0-9]%'username NOT LIKE '%[0-9]%';

The NOT LIKE '%[0-9]%' pattern is correct for excluding any username containing digits.

Q16

Single Choice

What does the following query do?

SQL Code

SELECT * FROM orders WHERE order_id NOT LIKE 'ORD%';

Selects orders whose order_id starts with 'ORD' Selects orders whose order_id does not start with 'ORD' Selects orders where order_id ends with 'ORD'Excludes orders where order_id contains 'ORD'

The NOT LIKE 'ORD%' pattern excludes any order_id that starts with 'ORD

Q17

Single Choice

Which SQL statement will return all rows where the phone_number column does not have a hyphen (-) as the second character?

SQL Code

SELECT * FROM contacts WHERE phone_number NOT LIKE '__-%';

NOT LIKE '-%' NOT LIKE '__-%' NOT LIKE '%-_'NOT LIKE '_%-_'

The pattern NOT LIKE '__-%' checks for a hyphen as the second character and excludes those records.

Q18

Single Choice

How does the NOT LIKE operator behave in the following query?

SQL Code

SELECT * FROM employees WHERE name NOT LIKE '%Smith';

It selects employees whose name starts with 'Smith' It selects employees whose name ends with 'Smith' It excludes employees whose name ends with 'Smith'It excludes employees whose name starts with 'Smith'

The pattern NOT LIKE '%Smith' excludes all names ending with 'Smith'.

Q19

Single Choice

What does the following SQL statement do?

SQL Code

SELECT * FROM logs WHERE entry NOT LIKE '%error%';

Selects all logs that contain 'error' Excludes logs that contain 'error' Selects only logs that start with 'error'Excludes logs that start with 'error'

The NOT LIKE '%error%' pattern excludes any logs that contain 'error'.

Q20

Single Choice

In a MySQL certification exam, which query would return customers whose email does not end with '.org'?

SQL Code

SELECT * FROM customers WHERE email NOT LIKE '%.org';

SELECT * FROM customers WHERE email LIKE '%.org'; SELECT * FROM customers WHERE email NOT LIKE '%.org'; SELECT * FROM customers WHERE email NOT LIKE '_%.org';SELECT * FROM customers WHERE email NOT LIKE '%.org%';

The NOT LIKE '%.org' pattern correctly excludes emails ending with '.org'.

Q21

Multiple Choice

Which query retrieves records from the 'employees' table where the 'name' does not start with the letter 'J'?

SQL Code

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

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

The NOT LIKE operator with 'J%' is used to filter rows where the 'name' column does not start with the letter 'J'.

Q22

Multiple Choice

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

SQL Code

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

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

The NOT LIKE operator with '%123' filters rows where the 'order_id' column does not end with '123'.

Q23

Multiple Choice

Which query correctly selects records from the 'products' table where 'product_name' does not contain the word 'Pro'?

SQL Code

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

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

The NOT LIKE operator with '%Pro%' is used to filter rows where the 'product_name' column does not contain the word 'Pro'.

Q24

Multiple Choice

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

SQL Code

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

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

The NOT LIKE operator with '%@example.com' filters rows where the 'email' column does not contain the domain 'example.com'.

Q25

Multiple Choice

Which SQL query retrieves records from the 'inventory' table where 'item_code' does not start with 'A' and end with 'Z'?

SQL Code

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

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

The NOT LIKE operator with 'A%Z' is used to filter rows where the 'item_code' column does not start with 'A' and end with 'Z'.

Q26

Multiple Choice

Which query correctly retrieves records from the 'sales' table where 'sales_rep' does not contain the letters 'ann'?

SQL Code

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

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

The NOT LIKE operator with '%ann%' filters rows where the 'sales_rep' column does not contain the letters 'ann'.

Q27

Multiple Choice

Determine the correct SQL query that selects records from the 'transactions' table where 'transaction_id' does not start with 'TX' and end with '99'.

SQL Code

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

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

The NOT LIKE operator with 'TX%99' is used to filter rows where the 'transaction_id' does not start with 'TX' and end with '99'.

Q28

Multiple Choice

Which SQL query retrieves records from the 'projects' table where 'project_name' does not start with 'Dev'?

SQL Code

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

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

The NOT LIKE operator with 'Dev%' is used to filter rows where the 'project_name' column does not start with 'Dev'.

Q29

Multiple Choice

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

SQL Code

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

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

The NOT LIKE operator with '%Corp%' is used to filter rows where the 'client_name' does not contain the word 'Corp'.

Q30

Multiple Choice

Which SQL query correctly retrieves records from the 'students' table where 'student_id' does not start with 'S' and end with '1'?

SQL Code

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

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

The NOT LIKE operator with 'S%1' is used to filter rows where the 'student_id' does not start with 'S' and end with '1'.

MySQL Database Quiz Questions