SQL Server uses fuzzy query to process special characters.

SQL Server uses fuzzy query to process special characters.

Today, when I was dealing with SQL queries, I encountered the like Query problem, so I analyzed the problem.

Problem:

Select * from v_workflow_rt_task_circulate where Name like '% [admin] application for leave of absence [to] %'

The data cannot be queried, but it exists in the database.

After modification:

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

Special characters (underlines _, percent %, square brackets [, tip ^) are required for fuzzy search)

Use square brackets to enclose the preceding characters ([]), for example, [_], [%], [[], and [^].

/*** Special characters must be processed for fuzzy search (underline _, percent %, square brackets [], tip number ^) * @ param Name * @ return */private String handleName (String name) {if (StringUtils. isEmpty (name) {return null;} return name. replace ("_", "[_]"). replace ("%", "[%]"). replace ("[", "[{]"). replace ("^", "[^]");}

The above section describes how to use fuzzy search in SqlServer to process special characters. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!