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

To select top 10 reads per month in WordPress, you need to use the Plugin CountPerDay. The following mysql snippet…

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…

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

To select a random row in MySQL you can use the following query. Sample MySQL

To replace a string in MySQL you can use the following snippet. Sample MySQL

To get the size of all databases in mysql you can use the following query. Sample MySql