mysql索引 - 为什么MySQL like查询是以%开头用不了索引?具体点,谢谢
阿神
阿神 2017-04-17 15:20:10
0
2
619

为什么MySQL like查询是以%开头用不了索引?

阿神
阿神

闭关修行中......

reply all(2)
伊谢尔伦

Think of an idiom dictionary, the kind that explains one idiom one by one.
For example, if you want to look up , but red is not at the beginning.
How do you check it?
You can only turn page by page.
Because if you look up the red letter, you will find that the red letter is the beginning word of the idiom.
If you search in the middle, you can’t find the index, because you don’t know where this dictionary is.
Think about it, is this true?

大家讲道理

The index is equivalent to a dictionary directory. You can quickly search if you know the beginning. If you don’t know the beginning, there is nothing you can do. You don’t know how to search the directory page

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template