开发者

How to match UTF8 characters in MySQL regular expression?

开发者 https://www.devze.com 2023-02-11 18:46 出处:网络
So I want to find out all the rows th开发者_StackOverflow社区at has UTF8 characters in a specific field, in this manner:

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

精彩评论

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