Sort by Specific Field-Values in a Field in MySql / MariaDB
Use this example to sort by a specific value in a field within your table, then sort by other fields.
MySql / MariaDB
This example shows you how to get the count of records within the last 7 days. In our table, we have the full date and time; This example shows all records for a complete day, grouped by day.
MySql
This example shows you how to randomize results returned in MySql / MariaDB
MySql / MariaDB
This example shows you how to use an origin table to create a new table, and populate the new table with contents from the origin.
MySql / MariaDB
Using INSERT SELECT to copy & populate one table from another.
MySql / MariaDB
How to fix the 1366 incorrect string value "\xE2\x80\x8B} ... error.
MySql / MariaDB
Retrieve Errors on Execution of a CakePHP Data Method (e.g. when saving)
CakePHP
Copy one table from another, across databases with MariaDB / MySql.
MySql / MariaDB
This example shows you how to replace strings in table rows for a specific database field.
MySql / MariaDB