Query to show records with 3 date criterias...

Join two tables in MySQL with random rows from the second...

CodeIgniter query() with unescaped single quotes in a single-quote SQL string gives a 1064 error...

CodeIgniter's update() query builder method corrupts the rendered SQL with backticks around each...

MySQL query fails after table qualifier on alias in CodeIgniter's select() method...

MySQL: Determine Table's Primary Key Dynamically...

How to get primary key of table?...

Why does my CodeIgniter model method return no results?...

Raw SQL executed with mysql_query() returns no results in CodeIgniter but works in phpMyAdmin...

How to filter database table results to the last 12 hours using CodeIgniter's query builder...

Convert raw MySQL query with SUM() expressions containing multiple conditions to CodeIgniter's q...

Object of class DateTime could not be converted to string...

Getting Sum of db field using join active record in codeigniter...

How to COUNT() the related records in a JOINed table per parent table row using a MySQL query...

H2 "runscript" command turns all table names into uppercase...

Why does my Left Join subquery only work with * instead of specifying the fields I need?...

How to save numbers to mysql database as it is?...

Why is my CodeIgniter SELECT SUM() query returning 1 row when there should be more?...

SELECT query with conditional expression in SUM() is rendered with incorrect backticks using CodeIgn...

MySQL SELECT query to SUM conditionally...

CodeIgniter Active Record - Get number of returned rows and get the sum...

How to use INSERT INTO in database where a condition is the ID has to be unique...

Am I Using JDBC Connection Pooling?...

How to join a table to this SQL code?...

What's the difference between utf8_general_ci and utf8_unicode_ci?...

How to SUM() two multiplied column values with CodeIgniter's query builder...

Get final balance with latest transaction per account with CodeIgniterfetching data from the table...

How to REGEXP for numbers that begin with a specific number in MySQL?...

SUM() values from a single column using CodeIgniter's query builder...

SELECT SUM() of column values from qualifying rows using CodeIgniter's query builder...