Jump to content

sql query

By joeri
July 21, 2012 in Support Forum

Share

https://forum.phpvms.net/topic/7644-sql-query/

Recommended Posts

Moderators

Newbie

joeri

Posted July 21, 2012

Moderators

- Report

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

Moderators

Rookie

mark1million

Posted July 21, 2012

Moderators

- Report

Posted July 21, 2012

HI mate you can do this,


UPDATE phpvms_pilots
SET `retired` = '2'
WHERE `retired` = '3'

Quote

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest

Reply to this topic...

× Pasted as rich text. Restore formatting

Only 75 emoji are allowed.

× Your link has been automatically embedded. Display as a link instead

× Your previous content has been restored. Clear editor

× You cannot paste images directly. Upload or insert images from URL.

Loading...

×

Share

https://forum.phpvms.net/topic/7644-sql-query/

Go to topic listing

×

×

Create New...