Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Why is MySQL's LIKE query also called Fuzzy query

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report