Search code examples
Query to show records with 3 date criterias...


mysqldateselect

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


phpmysqlcodeigniterselectquery-builder

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


sqlmysqlselectsubqueryleft-join

Read More
How to count the number of rows with a date from a certain year in CodeIgniter?...


phpdatecodeigniterselectcounting

Read More
How to execute a SELECT SUM() query using CodeIgniter's query builder methods...


phpcodeigniterselectsumquery-builder

Read More
How to get only the number from a string in MySQL?...


mysqlsqlstringselectnumbers

Read More
Query fails when Distinct is used...


phpmysqlsqlselectdistinct

Read More
Writing a SUBSTRING() call in CodeIgniter's select() method renders SQL with corrupted quotes...


phpcodeigniterselectquery-builderquoting

Read More
MySQL SELECT only not null values...


mysqlsqlselectnotnull

Read More
Codeigniter: Select from multiple tables...


phpcodeigniterjoinselectquery-builder

Read More
SELECT rows from one table where the same pair of columns are not found in another table using CodeI...


phpmysqlcodeigniterselectnot-exists

Read More
How to choose which comes first when specifying OR in SELECT statement...


mysqlselect

Read More
I need to merge empty values with same ID into 1 row, and add to same row also if multiple inputs...


mysqljoinselectgroup-bygroup-concat

Read More
Find an ID which contains 2 values in 2 lines...


sqlmysqlselect

Read More
How to select all rows containing a specific letter?...


mysqlselect

Read More
Select all from the db...


phpselectmysqlibind

Read More
Combine single MySQL result query & multi result query into one...


mysqlselect

Read More
Random row selection with different probabilities...


phpmysqlselectrandomprobability

Read More
Get the last row in a database table using CodeIgniter...


phpcodeigniterselectsql-order-bysql-limit

Read More
SQL select query with not not in clause...


sqlmysqlselect

Read More
Count items in SQL Table...


sqlmysqlselect

Read More
Selectively importing data in sql...


sqlselectconditional-statements

Read More
Oracle SQL -- Select all but entries that are blank or have spaces...


sqloracle-databaseselect

Read More
Undefined property when trying to access column not mentioned in CodeIgniter query's SELECT clau...


phpcodeigniterselectquery-builderresultset

Read More
NULL column value from LEFT JOINed table overwrites column with identical name in parent table when ...


phpcodeigniterselectquery-buildername-collision

Read More
Comma separated string of selected values in MySQL...


mysqlselectconcatenation

Read More
How to use CodeIgniter's select_max() and return other fields from the targeted row...


phpcodeigniterselectmaxquery-builder

Read More
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc...


sqldatabaseperformanceselectsqlperformance

Read More
MYSQL ERROR 1096 - NO TABLES USED - CODEIGNITER...


phpmysqlcodeigniterselectquery-builder

Read More
"No tables used" error when calling get() after query() in CodeIgniter...


phpcodeigniterselectquery-builder

Read More
BackNext