Stephen68 Posted November 25, 2007 Share Posted November 25, 2007 Hello all! I was wondering if you could do a multi line update with the WHERE clause, like. UPDATE table SET field='true' WHERE id='3,4,5,' I know this will not work because I tested it but can you do something along those lines? Any help would be greatly appreciated. Cheers! Stephen Quote Link to comment Share on other sites More sharing options...
fenway Posted November 25, 2007 Share Posted November 25, 2007 WHERE id IN ('3','4','5') Quote Link to comment Share on other sites More sharing options...
Stephen68 Posted November 25, 2007 Author Share Posted November 25, 2007 Thanks works great !! Stephen Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.