tqla Posted May 21, 2010 Share Posted May 21, 2010 I would like to delete every row in my Clients table except one that has the ID of 1091. I am trying this but I get an error: DELETE * FROM `Clients` WHERE ID != '1091' What is the correct syntax? Thanks! Link to comment https://forums.phpfreaks.com/topic/202537-help-with-delete-row-syntax/ Share on other sites More sharing options...
Mchl Posted May 21, 2010 Share Posted May 21, 2010 DELETE FROM `Clients` WHERE ID != '1091' Link to comment https://forums.phpfreaks.com/topic/202537-help-with-delete-row-syntax/#findComment-1061757 Share on other sites More sharing options...
tqla Posted May 21, 2010 Author Share Posted May 21, 2010 Worked! Thanks Mchl. Link to comment https://forums.phpfreaks.com/topic/202537-help-with-delete-row-syntax/#findComment-1061788 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.