Shulou(Shulou.com)05/31 Report--

What is the method of fuzzy query in SqlServer to deal with special characters? in order to solve this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Today, I encountered the problem that the sql query could not be queried by like, so I analyzed the problem.

Question:

Select * from v_workflow_rt_task_circulate where Name like'% [admin] request for leave [2017-02-13 to 2017-02-13]%'

Cannot be queried, but it exists in this piece of data in the database.

After modification:

Select * from v_workflow_rt_task_circulate where Name like'% [[] admin] request for leave [[] 2017-02-13 to 2017-02-13]%'

For fuzzy queries, special characters need to be handled (underscore _,%%, square brackets [, sharp ^)

The above characters are directly wrapped in square brackets ([]), for example: [_], [%], [[], [^].

/ * * Fuzzy query requires handling of special characters (underscore _,%%, square brackets [], cusp ^) * @ param Name * @ return * / private String handleName (String name) {if (StringUtils.isEmpty (name)) {return null } return name.replace ("_", "[_]") .replace ("%", "[%]") .replace ("[", "[{]") .replace ("^", "[^]") } the answer to the question about how to deal with special characters in SqlServer fuzzy query is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.