开发者

How to match UTF8 characters in MySQL regular expression?

So I want to find out all the rows th开发者_StackOverflow社区at has UTF8 characters in a specific field, in this manner:

SELECT * FROM table1 WHERE field1 REGEXP '[[:utf8:]]';

Searched through MySQL docs but found nothing. Is this possible?


I meant non-ASCII characters.

Managed to find a way to do that: http://www.kavoir.com/2011/03/mysql-find-non-ascii-characters.html

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜