db_like
function db_like
db_like($string)
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 DatabaseCondition::mapConditionOperator().
Parameters
$string: The string to escape.
Return value
The escaped string.
Related topics
File
- includes/database/database.inc, line 2646
- Core systems for the database layer.
Code
function db_like($string) { return Database::getConnection()->escapeLike($string); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!database.inc/function/db_like/7.x