Mysql數據庫like模糊查詢中文字段不準確的臨時解決辦法

select  *  from test.news where  binary title like  ' % s % '

字母區分大小寫

select  *  from test.news where  binary  ucase ( title )  like   ' % s % '