测试表数据的内容
日本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%';