Database: how to remove more than one actors?
In the exercise for removing data in - Remove actors with the first name "Yuri", "Walter" and "Victor".
My input is:
DELETE FROM actors WHERE name LIKE ("Yuri%" AND "Walter%" AND "Victor%);
Is the the correct format?
Steven Parker200,416 Points
You can't combine terms with
AND is for requiring all conditions at once,
OR is for any one of the conditions.
But you can combine complete expressions:
... name LIKE "Yuri%" OR name LIKE "Walter%" OR name LIKE "Victor%";
Matthew Wilkes4,809 Points
I used the below and this seemed to work for me:
DELETE FROM actors WHERE name IN ("Yuri", "Walter", "Victor")