SimplePortal

Support => English Support => Topic started by: fl4pj4ck on October 30, 2010, 10:19:22 PM

Title: mysql query to remove all articles
Post by: fl4pj4ck on October 30, 2010, 10:19:22 PM

could anyone help me and provide a sql query of how to remove all articles? I have something like 100 pages of them and would like to demote them from being displayed on the portal page

thanks!

Title: Re: mysql query to remove all articles
Post by: Nathaniel on November 01, 2010, 06:43:40 AM

If you have PhpMyAdmin or something similar installed on your webserver, then you can use the 'empty' command for the '{db_prefix}sp_articles' table.

Title: Re: mysql query to remove all articles
Post by: fl4pj4ck on November 01, 2010, 03:25:46 PM

thanks a lot!