Tag: mysql

To disable comments on posts older than date X in WordPress you can use the snippet below. Sample mySQL

To remove any post that is older than X days in WordPress you can use the query below. Sample mySQL

To disable or enable Trackbacks and Pingbacks in WordPress you can use the following mysql queries. Sample mySQL enable disable

To give a user admin rights in MySql you can use the following snippet. Sample mySql Query

To change user password in WordPress using MySql you can use the following query. Sample MySql

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…

To concat in MySQL you can use the concat or concat_ws function. Sample CONCAT output HELLO|WORLD|TEST Sample CONCAT_WS output HELLO|WORLD|TEST for more informations see DEV.MYSQL: Concat, CONCAT_WS

To rearrange columns in MySQL you can use the following snippet.

To copy a table in MySQL you can use the following snippet. Sample MySQL

To select entries less than 24 hours old in MySQL you can use the following snippet. Sample MySQL