首页 > 技术文章 > Mysql特殊字符处理

lxmzq 2020-04-08 10:47 原文

public static class MysqlSpecialCharactersHelper
    {
        /// <summary>
        /// Mysql特殊字符处理
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        public static string SpecialCharactersTransfer(this string source)
        {
            source = source.Replace(@"\", @"\\\\\");
            source = source.Replace(@"'", @"\'");
            source = source.Replace(@"_", @"\_");
            source = source.Replace(@"%", @"\%");
            return source;
        }
    }

 

推荐阅读