Implementation Method Based on SQLite special character escape

Select
* Fromtablewhere number like '%/%' escape '/'...
When the sqlite3 database is searching, some special characters need to be escaped. The specific escape is as follows:
/-> //
'->''
[-> /[
]->/]
%->/%
&-> /&
_-> /_
(-> /(
)-> /)
Note that special characters do not use the Backslash "\" to indicate escape characters. CopyCodeThe Code is as follows: public static string sqliteescape (string keyword ){
Keyword = keyword. Replace ("/","//");
Keyword = keyword. Replace ("'","''");
Keyword = keyword. Replace ("[","/[");
Keyword = keyword. Replace ("]", "/]");
Keyword = keyword. Replace ("%", "/% ");
Keyword = keyword. Replace ("&","/&");
Keyword = keyword. Replace ("_","/_");
Keyword = keyword. Replace ("(","/(");
Keyword = keyword. Replace (")","/)");
Return keyword;
}