Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialSambath 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?
3 Answers
Steven Parker
231,269 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,810 PointsI used the below and this seemed to work for me:
DELETE FROM actors WHERE name IN ("Yuri", "Walter", "Victor")
Steven Parker
231,269 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
Full Stack JavaScript Techdegree Graduate 27,765 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.
Kate McPherson
2,150 PointsIn case anyone is looking for the same answer that I have been looking for regarding how to leave out the entries like "Yuriko" - you need to leave a space between the text and the % wildcard.
Instead of "Yuri%" it needs to be "Yuri %". You can do the same with Victor to leave out any Victorias.
Christian Higgins
15,758 PointsChristian Higgins
15,758 PointsWould this also delete the actresses named "Victoria"?
Steven Parker
231,269 PointsSteven Parker
231,269 PointsIt would! So perhaps a better solution would be to include a space between the name and the "%" symbol.