Shulou(Shulou.com)06/01 Report--

The following brings you about why the LIKE query of MySQL is also called fuzzy query, if you are interested, let's take a look at this article. I believe that after reading MySQL's LIKE query, why it is also called fuzzy query is more or less helpful to everyone.

In some small websites, mysql uses like query statement, referred to as fuzzy query, using the percent sign% character to represent any character as the query standard, here is a brief description of the common usage. 1, the standard usage SELECT * FROM position WHERE name LIKE'% www..dc3688.com%'; 2, the other uses like matching / fuzzy matching, will be used in combination with% and _. '% a' / / data ending with a' a%'/ / data starting with a'% a%'/ / data with three digits of'_ a'/ / with the middle letter of'_ a'/ / two digits of an and ending with two digits of'a'/ / with the letter beginning with a SELECT * FROM dc3688 WHERE name LIKE'% dc3688' SELECT * FROM dc3688 WHERE name LIKE 'dc3688%'

Look at the above LIKE query about MySQL why it is also called fuzzy query details, whether there is anything to gain. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.