PostgreSQL PGCES-02 Exam - Topic 2 Question 91 Discussion

Question

You want to delete rows in the "product" table which include the value '2004' in the "name" field. Select the correct statement to achieve this task.

A) DELETE product WHERE name ~ '2004';

B) DELETE product WHERE contain(name, '2004');

C) DELETE FROM product WHERE name IN '2004';

E) DELETE FROM product WHERE name SIMILAR TO '2004';

Accepted Answer

D) DELETE FROM product WHERE name LIKE '%2004%';

Contribute your Thoughts: