米粒

Wednesday, October 12, 2016

mysql识别字段中包含中文的方法

select
HEX('服务器无响应') REGEXP '^(..)*(E[4-9])'



参见http://stackoverflow.com/questions/9795137/how-to-detect-rows-with-chinese-characters-in-mysql
Posted by 米粒 at 12:10 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

米粒
View my complete profile

Blog Archive

  • ►  2020 (5)
    • ►  September (2)
    • ►  August (1)
    • ►  July (1)
    • ►  March (1)
  • ►  2019 (11)
    • ►  December (2)
    • ►  October (1)
    • ►  July (2)
    • ►  April (2)
    • ►  March (4)
  • ►  2018 (11)
    • ►  November (1)
    • ►  October (1)
    • ►  July (1)
    • ►  May (3)
    • ►  April (5)
  • ►  2017 (29)
    • ►  December (3)
    • ►  September (1)
    • ►  August (1)
    • ►  July (5)
    • ►  June (4)
    • ►  May (1)
    • ►  April (6)
    • ►  March (2)
    • ►  February (4)
    • ►  January (2)
  • ▼  2016 (24)
    • ►  December (2)
    • ►  November (5)
    • ▼  October (3)
      • MySQL存储emoji表情报错
      • mysql识别字段中包含中文的方法
      • git push origin v0.1
    • ►  August (5)
    • ►  July (3)
    • ►  June (1)
    • ►  May (2)
    • ►  March (2)
    • ►  February (1)
  • ►  2015 (8)
    • ►  December (4)
    • ►  November (2)
    • ►  October (1)
    • ►  September (1)

Total Pageviews

Simple theme. Powered by Blogger.