MySQL JOIN / GROUP_CONCAT second table?...

#1062 - Duplicate entry for key 'PRIMARY'...

how to get result of group by with join...

Getting MySQL results based on date by current month in Codeigniter...

Convert raw SQL with comma-JOINed tables related by identically named columns to CodeIgniter's q...

Operator '&' is not defined for types 'String' and 'Control'...

Optimizing SQL statements to reduce MySQL server load...

Mysql Mariadb recursive query...

Insert multiple rows with one query MySQL...

ERROR: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of...

How to add 1 month to a MySQL TIMESTAMP in PHP...

How to use MySQL's TIME_FORMAT() to convert "H:i:s" time to "h:i p" format...

MySQL get mixed result from 2 queries on same table with different order...

How to convert a MySQL timestamp (Y-m-d H:i:s) into a "M j Y g:i A" formatted string...

How to connect to mysql from C# over SSH...

How to convert a MySQL query result's datetime string from "Y/m/d H:i:s" format to &qu...

How to change a MySQL column name that has # (Hash) symbol...

SELECT rows WHERE date column is between the start of a given month and the end of another month usi...

Adding a column to an SQL query based on join...

How to use Coalesce in MySQL...

Deleting rows from 3 tables at once in PHP...

Combine SELECT and UPDATE to avoid duplicate selects...

CodeIgniter's select() method containing aliased columns and an SQL function emits a query error...

MySQL - How to use SELECT to get only special characters in UTF8...

PDO were rows affected during execute statement...

SELECT rows WHERE datetime column is between two dates with CodeIgniter...

SELECT rows WHERE a VARCHAR datetime column formatted as d-m-Y H:i:s matches a given date value with...

Scraping lottery draw data live - can I find appropriate results? How can I combine so many sources?...

DELETE rows from a table if datetime column value is more than 1 minute old using CodeIgniter...

Comparing d/m/Y dates with CodeIgniter's query builder methods and STR_TO_DATE() is returning in...