Queries 6. Like - II


#1

SELECT * FROM movies
WHERE name BETWEEN 'A' AND 'J';

DELETE FROM movies
WHERE name BETWEEN 'A' AND 'J';

SELECT * FROM movies
WHERE year BETWEEN 1990 AND 2000;

I need to Delete the above query I know I did this wrong, but the rest my code is correct. Any tips.!!!


#2

You could using the * selector with the regular delete syntax, though make sure you still have your where clause included. Delete right now is only looking for one row but you're giving it a broad range, you need to swap that around, give it a larger selector, but narrow the conditions.