Results 1 to 10 of 10

Thread: Delete All Listing with SQL

  1. #1
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete All Listing with SQL

    I have over 20,000 listings that I imported (yes that took a while using small file sizes) and I would like to use SQL to quickly delete them so I can redo my listings. I am new to WordPress and PHP but I have worked with SQL for over 13 years so I do feel comfortable with SQL. I did do a backup before I loaded the listings, but I added some pages that I don't want to drop so I was hoping for a fast SQL alternative to remove the listings.

    I appreciate the help!

  2. #2
    red20me's Avatar
    Join Date
    Jul 2013
    Location
    United Kingdom
    Posts
    473
    Thanks
    1
    Thanked 104 Times in 93 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  5. #5
    red20me's Avatar
    Join Date
    Jul 2013
    Location
    United Kingdom
    Posts
    473
    Thanks
    1
    Thanked 104 Times in 93 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  6. #6
    Senior Member junnydc's Avatar
    Join Date
    Aug 2011
    Location
    Singapore
    Posts
    198
    Thanks
    20
    Thanked 9 Times in 8 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  7. #7
    dimitris's Avatar
    Join Date
    Oct 2011
    Location
    Earth
    Posts
    20,617
    Thanks
    222
    Thanked 1,873 Times in 1,770 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  8. #8
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  9. #9
    joes's Avatar
    Join Date
    Nov 2012
    Location
    Australia
    Posts
    877
    Thanks
    12
    Thanked 358 Times in 261 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  10. #10
    Thread Starter
    Expired Customer mfbrummett's Avatar
    Join Date
    Nov 2013
    Location
    United States
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Is there a delete listing option in Vantage 1.1.1
    By mediacomnc in forum Vantage General Discussion (Legacy)
    Replies: 7
    Last Post: March 15th, 2015, 02:51 AM
  2. Dimitris listing owner - delete own listing
    By tradeamillion in forum Help Using Vantage (Legacy)
    Replies: 4
    Last Post: November 20th, 2013, 05:30 PM
  3. Delete listing in Vantage does not delete the geodata
    By joes in forum Report Vantage Bugs (Legacy)
    Replies: 4
    Last Post: November 29th, 2012, 10:55 PM
  4. How to delete /Ad Category/ &/Ad Listing/ in the Url
    By tech9 in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: April 12th, 2012, 09:58 AM
  5. Single Ad Listing (Sidebar): Delete Subcategories box
    By lcolley in forum ClassiPress General Discussion
    Replies: 2
    Last Post: August 13th, 2010, 02:21 PM