select Examples and Free Source Code

codeigniter differentiate field names in JOINed tables...

php codeigniter select query-builder name-collision

Displaying Data from a Join in Codeigniter 2.2.1...

php codeigniter select query-builder codeigniter-2

Codeigniter database query bug - does not return expected results...

php codeigniter select prepared-statement sql-injection

SELECT MySQL rows where today's date is between two DATE columns...

mysql select

Why doesn't CodeIgniter's order_by() affect query()?...

php codeigniter select sql-order-by query-builder

How to access two databases in a single SELECT query with CodeIgniter's query builder...

php codeigniter select query-builder multiple-databases

How to add an ORDER BY clause using CodeIgniter's query builder...

php codeigniter select sql-order-by query-builder

Complex MySQL SORT based on time...

mysql sorting select

Selective query...

mysql select

I want to modify this SQL statement to return only distinct rows of a column...

sql mysql select distinct

MySQL SELECT query WHERE timestamp falls on the current date...

mysql date select timestamp where-clause

SELECT rows for user where column value is in the future with CodeIgniter...

php datetime codeigniter select quoting

Is there an equivalent to SELECT t1.* when there is a USING() clause?...

sql oracle-database join select

Why does my single-table SELECT query using CodeIgniter's query builder have an error before the...

php mysql codeigniter select query-builder

Codeigniter: Select from multiple tables...

php codeigniter join select query-builder

Query to show records with 3 date criterias...

mysql date select

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

php mysql codeigniter select query-builder

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

sql mysql select subquery left-join

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

php date codeigniter select counting

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

php codeigniter select sum query-builder

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

mysql sql string select numbers

Query fails when Distinct is used...

php mysql sql select distinct

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

php codeigniter select query-builder quoting

MySQL SELECT only not null values...

mysql sql select notnull

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

php mysql codeigniter select not-exists

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

mysql select

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

mysql join select group-by group-concat

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

sql mysql select

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

mysql select

Select all from the db...

php select mysqli bind