Removing unwanted airports (Solved)

[clawsonsa]

Fellow members,

Is there and easy way to remove a large number of unwanted airports from your database with removing them one at a time in the edit area of the admin panel?

Thank you.

Scott C

[RogerB]

MySql

[mark1million]

Yes there is, i done it with my lot a while ago through phpmyadmin, i cant remember the exact query now but do a backup of that table just incase things get screwed, they you can restore if it goes wrong.

You can use wild cards so,

DELETE FROM `phpvms_airports`

WHERE `icao` =LP**

Something like that "NOT TESTED" so make sure you test first

[PilotJordan]

The easiest way is if you have phpMyAdmin which most hosts do. Just go to your cPanel and click the icon the says phpmyadmin and click on your tables, find the phpvms_airports table select the checkbox for the ones you wish to remove and remove them.

Although the alternative if you don't have phpmyadmin is using an SQL query.

[clawsonsa]

Thank you

I appreciate the help!