select Examples and Free Source Code

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

Codeigniter: Select from multiple tables...

php codeigniter join select query-builder

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

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

mysql select

Random row selection with different probabilities...

php mysql select random probability

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

php codeigniter select sql-order-by sql-limit

SQL select query with not not in clause...

sql mysql select

Count items in SQL Table...

sql mysql select

Selectively importing data in sql...

sql select conditional-statements

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

sql oracle-database select

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

php codeigniter select query-builder resultset

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

php codeigniter select query-builder name-collision

Comma separated string of selected values in MySQL...

mysql select concatenation

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

php codeigniter select max query-builder

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

sql database performance select sqlperformance

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

php mysql codeigniter select query-builder

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

php codeigniter select query-builder