Sambath Phum
4,089 PointsDatabase: 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?
2 Answers
Steven Parker
207,999 PointsYou can't combine just terms with AND.
And 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 Wilkes
4,809 PointsI used the below and this seemed to work for me:
DELETE FROM actors WHERE name IN ("Yuri", "Walter", "Victor")
Steven Parker
207,999 PointsSure, but you can't use the wildcard "%" when using the membership operator ("IN"). It only works with "LIKE".
The "IN" operator only works with exact matches.
But as you discovered, wildcards are not needed for this challenge.
Joseph Lander
Front End Web Development Techdegree Graduate 24,869 PointsThat didn't work for me? Names starting with "Yuri" are still there. Doesn't this mean it is looking for an exact match? It won't be as there is a lastname.
Christian Higgins
15,757 PointsChristian Higgins
15,757 PointsWould this also delete the actresses named "Victoria"?
Steven Parker
207,999 PointsSteven Parker
207,999 PointsIt would! So perhaps a better solution would be to include a space between the name and the "%" symbol.