reslove the problem when use ngx.quote_sql_str for str which contains whitespace

  Seves

原文链接:reslove the problem when use ngx.quote_sql_str for str which contains whitespace

reslove the problem when use ngx.quote_sql_str for str which contains whitespace:

the ngx.quote_sql_str function while delete the whitespace ,it while not records when query in database,the relove is to use replace funtion in sql str to delete the whitespace,example:

“select * from tablexxx where replace(searchkey,’ ‘,’’) like " .. ngx.quote_sql_str(”%“..searchkey..”%")


本文链接:https://www.fcblog.top/reslove-the-problem-when-use-quote_sql_str-for-str-which-contains-whitespace.html

fc
800