bigquery sql　正则表达式

匹配中文，英文字母和数字及_:

SELECT * FROM `heidao-market.mafia1.chat` WHERE regexp_contains(message ,'^[\u4e00-\u9fa5_a-zA-Z0-9]+$') --and DATE(timestamp) = "2019-09-11" and length(message )>3

匹配中文，降序排列

SELECT * FROM `cloud-test-199409.ledi7.message_count` where length(message )>20 and cntmsge >5 order by cntmsge desc

匹配英文

--'^[\u4e00-\u9fa5_a-zA-Z0-9]+$' --[a-zA-Z]SELECT * FROM `heidao-market.mafia1.chat` WHERE regexp_contains(message ,'[a-zA-Z]') --and regexp_extract_all(value, regex)(message , '^[^\x00-\xff]+$') --and DATE(timestamp) = "2019-09-11" and length(message )>3 select * from `mafia1.chat` where player_id in ( select player_id from(SELECT player_id ,max(after_lev) as mansion_level FROM `heidao-market.mafia1.building_levelup` WHERE DATE(timestamp) > "2019-08-01" and building_id=101 group by player_id) where mansion_level>5 and mansion_level<10 and player_id in( select player_id from (SELECT player_id ,max(new_lev) as lord_level FROM `heidao-market.mafia1.level_up` WHERE DATE(timestamp) > "2019-08-01" group by player_id ) where (lord_level>3 and lord_level<7 ))) and date(timestamp)='2019-09-09' and channel =3

总结

以上是生活随笔为你收集整理的bigquery sql　正则表达式的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。