Category: MySql

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 will do the rest. Sample MySQL

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

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