Moderators joeri Posted July 21, 2012 Moderators Report Share Posted July 21, 2012 hey all i need a quick help i want to change all my pilots on leave to retired as it seems the system is setting all retired pilots on leave how do i setup the sql query to change the numbers from 3 to 2 regards joeri Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted July 21, 2012 Moderators Report Share Posted July 21, 2012 HI mate you can do this, UPDATE phpvms_pilots SET `retired` = '2' WHERE `retired` = '3' 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.