public function Connection::escapeLike

Escapes characters that work as wildcard characters in a LIKE pattern.

The wildcard characters "%" and "_" as well as backslash are prefixed with a backslash. Use this to do a search for a verbatim string without any wildcard behavior.

For example, the following does a case-insensitive query for all rows whose name starts with $prefix:

$result = db_query('SELECT * FROM person WHERE name LIKE :pattern', array(
  ':pattern' => db_like($prefix) . '%',
));

Backslash is defined as escape character for LIKE patterns in Drupal\Core\Database\Query\Condition::mapConditionOperator().

Parameters

$string: The string to escape.

Return value

The escaped string.

File

drupal/core/lib/Drupal/Core/Database/Connection.php, line 855
Definition of Drupal\Core\Database\Connection

Class

Connection
Base Database API class.

Namespace

Drupal\Core\Database

Code

public function escapeLike($string) {
  return addcslashes($string, '\\%_');
}