Question about DELETE FROM
Posted by:
InvaderCyn
(---.ptld.qwest.net)
Date: July 09, 2009 10:32PM
I am working through the Head First SQL book and I ran into a problem. I can't delete a row with the DELETE FROM command.
My database has two entries in it: (shortened for simplicity)
name activities
Clarabelle yelling, dancing
Clarabelle dancing
I have been trying to remove the one that has the activities 'yelling, dancing'
DELETE FROM clown_info
WHERE activities = 'yelling'
AND name = 'Clarabelle';
and
DELETE FROM clown_info
WHERE activities = 'yelling%'
AND name = 'Clarabelle';
Both of these find no queries to modify. What am I doing wrong? Shouldn't I be able to delete a row based on parial information?
Please help!