or_not_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using OR NOTs for the conditions inside it.

or_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to match $side (string) – Which side of the expression to put the ‘%’ wildcard on $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a LIKE clause to a query, separating multiple class with OR.

or_having($key[, $value = NULL[, $escape = NULL]]) Parameters: $key (mixed) – Identifier (string) or associative array of field/value pairs $value (string) – Value sought if $key is an identifier $escape (string) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a HAVING clause to a query, separating multiple calls with OR.

or_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using ORs for the conditions inside it.

order_by($orderby[, $direction = ''[, $escape = NULL]]) Parameters: $orderby (string) – Field to order by $direction (string) – The order requested - ASC, DESC or random $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds an ORDER BY clause to a query.

offset($offset) Parameters: $offset (int) – Number of rows to skip Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds an OFFSET clause to a query.

not_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to match $side (string) – Which side of the expression to put the ‘%’ wildcard on $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a NOT LIKE clause to a query, separating multiple calls with AND.

not_group_start() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Starts a group expression, using AND NOTs for the conditions inside it.

limit($value[, $offset = 0]) Parameters: $value (int) – Number of rows to limit the results to $offset (int) – Number of rows to skip Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds LIMIT and OFFSET clauses to a query.

like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to match $side (string) – Which side of the expression to put the ‘%’ wildcard on $escape (bool) – Whether to escape values and identifiers Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Adds a LIKE clause to a query, separating multiple calls with AND.