mysql用like有些汉字查询不到_Mysql选择与LIKE子句不工作的汉字

测试表数据的内容

日本English Characters

English Characters日本

日本

English Characters

其次是

I have data stored in single column which are in English and

Chinese

你的选择应该是这样的

SELECT * FROM tab

WHERE content LIKE '%%%'

SQL Fiddle DEMO(还有演示如何获得特殊语言部分内容)

SET @PRE = '', @SUF = '';

SELECT

content,

SUBSTR(

content,

LOCATE( @PRE, content ) + LENGTH( @PRE ),

LOCATE( @SUF, content, LOCATE( @PRE, content ) ) - LOCATE( @PRE, content ) - LENGTH( @PRE )

) langcontent

FROM tab

WHERE content LIKE CONCAT( '%', @PRE, '%', @SUF, '%' );

SELECT 'David!' LIKE '%D%v%';