A like wildcard special character handling in SQL

Here are some examples of matches, and it should be explained that only the like operation has these special characters, = operation is not.
A_b ... a[_]b%
A%b ... a[%]b%
A[b ... a[[]b%
A]b ... a]b%
A[]b ... a[[]]b%
A[^]b ... a[[][^]]b%
a[^^]b ... a[[][^][^]]b%

1. In the actual processing, for the = operation, we generally only need to replace this:
', '

2. For the like operation, the following substitutions are required (note the order is also important)
[[[] (This must be the first replacement!!!)
%, [%] (here% means that the characters you want to match include the% instead of a wildcard that is specifically used for matching)
_, [_]
^-[^]

For more information, see:

SQL like wildcard character fuzzy query techniques and special characters-http://blog.csdn.net/lisliefor/article/details/6547861

A like wildcard special character handling in SQL