KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
With MYSQL I'm using this query: UPDATE CustomerDetails_COPY SET Category_ID = 10 WHERE Category_ID = 2 Thats fine but I'd like to ad 15+ more SET/WHERE to it like: UPDATE CustomerDetails_COPY SET Category_ID = 9 WHERE Category_ID = 3 SET Category_ID = 12 WHERE Category_ID = 4 SET Category_ID = 11 WHERE Category_ID = 5 ..... How would I add to this? EDIT: As Per Hunters Suggestion: UPDATE CustomerDetails_COPY SET Category_ID = CASE Category_ID WHEN 2 THEN 10 WHEN 3 THEN 9 WHEN 4 THEN 12 WHEN 5 THEN 11 END WHERE Category_ID IN (2,3,4,5) This works Great! Thanks
Tags (comma-separated)
Save Edits
Cancel