What are implications to using "date" as a MySQL column name?...

How to compare two table columns passed to CodeIgniter's where() in associative array...

subquery column missing values in outer SELECT - What's happening?...

Which performs better in a MySQL where clause: YEAR() vs BETWEEN?...

How to use CodeIgniter to perform a multi-keyword search across multiple tables and identify the sou...

Switching from MySQL to Cassandra - Pros/Cons?...

Conditionally search multiple tables in CodeIgniter...

How to query multiple database tables with LIKE keyword conditions via one CodeIgniter query...

Does each database table need its own model in a CodeIgniter MVC?...

Laravel query builder using 'whereNotIn' throws error...

MYSQL - count number of rows in each table...

Cannot delete or update a parent row: a foreign key constraint fails...

Condensing a query into a single better formatted query...

Redact the column in a SELECT clause depending on a condition using CodeIgniter's active record...

get images list according to there message and thread id from database...

How to do a negative foreign key check (constraint to foreign table) in MySQL?...

how to convert mysqli_set_charset($conn,"utf8") into PDO format in MYSQL?...

MySQL, join to find only max transaction count based of group...

CodeIgniter SELECT query with JOIN conditions using FIND_IN_SET() is not returning the expected resu...

How to only append a wildcard at the end of a WHERE LIKE condition with CodeIgniter's active rec...

How to separate logic in a Codeigniter active record WHERE clause...

Does the JDBC specification define what happens if you call ResultSet.getObject(String) for a query ...

Chronologically order a SELECT query's results by month name...

Calculate tiered discount amount using a CodeIgniter query...

Join query with comma separated values in codeigniter...

What is an elegant way to deal with several optional filters?...

#1130 - Host 'localhost' is not allowed to connect to this MySQL server - After running an A...

Detect mysql update/insertion failure due to violated unique constraint...

Duplicate table entry error...

Catch duplicate key insert exception...