When using ThinkPHP for fuzzy data query, it is often necessary to use the percent sign (%) for wildcard matching to achieve a more precise search. This article will introduce how to correctly use the percent sign to implement fuzzy queries.

1. Using the percent sign in the like() method

When using the like() method for fuzzy query, you need to pass the percent sign as a parameter to the method. . For example, if you want to query user information for "username starting with 'a'", you can use the following code:

$userList = Db::table('user')->where('username', 'like', 'a%')->select();

In this example, we pass "a%" to the like() method, indicating that we To query the information of all users whose username starts with "a".

2. Escape the percent sign using an escape character

If we need to actually query data that contains the percent sign character, we need to escape it using an escape character , otherwise a SQL statement error will occur. In ThinkPHP, use backslash "" to escape percent signs.

For example, if we want to query user information containing the string "?c%", we can use the following code:

$userList = Db::table('user')->where('username', 'like', '%abc%')->select();

In this example, we use backslashes for the percent sign Escaped to avoid SQL statement errors.

3. Use the escape() method to escape a string

If we want to query data containing percent characters, but do not want to manually escape the percent every time No., you can use the escape() method to automatically escape the string.

For example, if we want to query user information containing the "?c%" string, we can use the following code:

$keyword = '%abc%';
$escapedKeyword = Db::escapeLikeStr($keyword);
$userList = Db::table('user')->where('username', 'like', $escapedKeyword)->select();

In this example, we use the escape() method to $ The percent sign character in the keyword is automatically escaped to the "%" form, thus avoiding the tedious operation of manual escaping.

Summary

When using ThinkPHP for fuzzy queries, it is very important to use the percent sign correctly. Through the above introduction, we can master three methods of using the percent sign, namely using the percent sign in the like() method, using escape characters to escape the percent sign, and using the escape() method to automatically escape strings. Hope this article is helpful to you.

The above is the detailed content of How to use fuzzy percent sign in thinkphp. For more information, please follow other related articles on the PHP Chinese website!