where-clause Examples and Free Source Code

SELECT query with WHERE clause containing CONCAT() and REGEXP using CodeIgniter's query builder...

php codeigniter concatenation where-clause query-builder

Condition in WHERE Clause...

sql sql-server case where-clause

When to use codeigniter where() function and when get_where()...

php codeigniter where-clause query-builder

How to pass multiple WHERE conditions using CodeIgniter's get_where() method...

php codeigniter where-clause query-builder method-parameters

SELECT rows WHERE a date column value equals one of three values using CodeIgniter's query build...

php codeigniter where-clause query-builder between

SELECT rows WHERE a column value is found in a foreign table's column using CodeIgniter's qu...

php codeigniter where-clause query-builder exists

Multiple values from case expression then...

sql oracle-database oracle11g case where-clause

Performance of CASE expression in WHERE condition...

sql performance case where-clause

Convert OR operator to case expression...

mysql sql case query-optimization where-clause

Convert raw SQL containing the same calculation the SELECT and WHERE clause to CodeIgniter's que...

php codeigniter where-clause query-builder codeigniter-query-builder

Case expression for 'where [value] is not null'...

sql null case where-clause

CASE expression in WHERE...

sql t-sql case where-clause

Case Expression Inside Where Clause...

sql where-clause case

Pass every two elements of an indexed array as column => value parameters for CodeIgniter's w...

php arrays codeigniter activerecord where-clause

Optimizing query with nested where clauses...

sql nested firebird where-clause

Postgres chkpass compares 'contain' and not 'equal'...

postgresql compare where-clause equality

Passing a string of WHERE conditions to CodeIgniter's get_where() method renders an invalid quer...

php mysql codeigniter where-clause query-builder

Codeigniter - How to get records from database where one fields value is more than another?...

php mysql codeigniter where-clause query-builder

CodeIgniter Query Builder WHERE a column value is greater than another column value...

php codeigniter where-clause comparison query-builder

What is the difference between HAVING and WHERE?...

sql where-clause having

CodeIgniter JOINed tables returning results which should be disqualified by WHERE condition...

php codeigniter join where-clause query-builder

How to write a WHERE clause with two separate comparisons with CodeIgniter's query builder...

php codeigniter where-clause query-builder

SELECT rows WHERE date column value is between two given datetime values with CodeIgniter's quer...

php codeigniter where-clause query-builder date-comparison

SELECT rows WHERE datetime column is between two dates with CodeIgniter...

php mysql datetime codeigniter where-clause

Dynamic WHERE clause IN LOOP AT statement...

loops dynamic where-clause abap

Checking an input parameter if not Null and using it in where...

sql sql-server sql-server-2008 where-clause coalesce

SQL function in a key of the array passed to CodeIgniter's get_where() omits expected equals sym...

php mysql codeigniter where-clause query-builder

How to encapsulate the logic of OR conditions with CodeIgniter's query builder methods...

php codeigniter where-clause query-builder logical-grouping

Left Join With Where Clause...

sql left-join where-clause

MySQL query WHERE all values in a comma-separated string are found in a comma-separated table column...

mysql where-clause intersection find-in-set