Login Register

CI_DB_query_builder::like()

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.

Links:

http://www.codeigniter.com/user_guide/database/query_builder.html#CI_DB_query_builder::like

doc_CodeIgniter

2016-10-15 16:31:16

Comments

Leave a Comment

Please login to continue.

Popular Articles

CI_DB_query_builder class CI_DB_query_builder reset_query() Returns: CI_DB_query_builder instance (method chaining) Return type: CI_DB_query_builder Resets the cur

CI_DB_query_builder::delete() delete([$table = ''[, $where = ''[, $limit = NULL[, $reset_data = TRUE]]]]) Parameters: $table (mixed) – The table(s) to delete from; string or

CI_DB_query_builder::limit() 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::not_like() not_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to

CI_DB_query_builder::or_like() or_like($field[, $match = ''[, $side = 'both'[, $escape = NULL]]]) Parameters: $field (string) – Field name $match (string) – Text portion to m