To disable comments on posts older than date X in WordPress you can use the snippet below.
Sample mySQL
UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2013-01-01' AND post_status = 'publish'
mysql
How to remove any post that is older than X days in WordPress
To remove any post that is older than X days in WordPress you can use the query below.
Sample mySQL
DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > X
How to disable or enable Trackbacks and Pingbacks in WordPress
To disable or enable Trackbacks and Pingbacks in WordPress you can use the following mysql queries.
Sample mySQL
enable
UPDATE wp_posts SET ping_status = 'open';
disable
UPDATE wp_posts SET ping_status = 'closed';
How to give a user admin rights in mySql
To give a user admin rights in MySql you can use the following snippet.
Sample mySql Query
GRANT ALL PRIVILEGES ON myDbName.* TO 'myUserName'@'%' WITH GRANT OPTION;
How to change user password in WordPress using MySql
To change user password in WordPress using MySql you can use the following query.
Sample MySql
UPDATE wp_users SET user_pass = MD5('NewPassword') WHERE user_login = 'UserName';
How to change default Admin Username in WordPress
Every default WordPress installation will create an account with a default Admin username. This can be a security issue.
To change default Admin Username in WordPress you can use the mySql snippet below.
UPDATE wp_users SET user_login = 'NewUsername' WHERE user_login = 'Admin';
How to concat in MySQL
How to rearrange columns in MySQL
To rearrange columns in MySQL you can use the following snippet.
ALTER TABLE TABLENAME MODIFY COLUMN COLUMNNAME TYPE AFTER COLUMNNAME
How to copy a table in MySQL
To copy a table in MySQL you can use the following snippet.
Sample MySQL
CREATE TABLE NEWTABLE LIKE OLDTABLE; INSERT NEWTABLE SELECT * FROM OLDTABLE;
How to select entries less than 24 hours old in MySQL
To select entries less than 24 hours old in MySQL you can use the following snippet.
Sample MySQL
SELECT * FROM TABLENAME WHERE COLUMNNAME >= DATE_SUB(Now(),INTERVAL 24 HOUR)