Laravel:转义为"LIKE"条款? [英] Laravel: Escape "LIKE" clause?

问题描述

如何在Laravel/Eloquent中转义LIKE子句?例如，

How can I escape a LIKE clause in Laravel/Eloquent? e.g.,

$search = Input::query('sSearch', '');
if($search !== '') {
    $paginatedBookings->where('first_name', 'LIKE', '%' . $search . '%');
}

如果$search包含%或_，则需要对其进行转义.

If $search contains a % or _ they need to be escaped.

推荐答案

另一个答案忘记了转义字符本身，这是一个更可靠的解决方案:

The other answer forgets about escaping the escape character itself, here is a more robust solution:

/**
 * Escape special characters for a LIKE query.
 *
 * @param string $value
 * @param string $char
 *
 * @return string
 */
function escape_like(string $value, string $char = '\\'): string
{
    return str_replace(
        [$char, '%', '_'],
        [$char.$char, $char.'%', $char.'_'],
        $value
    );
}

这篇关于Laravel:转义为"LIKE"条款?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！