具体的表是这样的:(有几万条呢,我只选择几条记录) userid doc_title mzp922 Desilication: on the controlled generation of mesoporosity in MFI zeolites pumc1917 Resolving the gatekeeper conundrum: what patients value in primary shaangu 自主创新的三机同轴BPRT机组 shaangu 膨胀机斜安装叶片的尺寸误差分析 ketu Antihypertensive treatment and CHD in the elderly (letter) yiby EQUATIONS OF MOTION FOR TRAIN DERAILMENT DYNAMICS penggl 公安部队的魔杖-非致命武器就是说:doc_title字段的值有的是中文,有的是英文,我想判断一下中、英文分别多少条。
假设使用UTF8字符集,内容有汉字都算 ELECT * FROM tt WHERE doc_title REGEXP '[^ -~]'
aced中文rrr:算什么?
userid doc_title
mzp922 Desilication: on the controlled generation of mesoporosity in MFI zeolites
pumc1917 Resolving the gatekeeper conundrum: what patients value in primary
shaangu 自主创新的三机同轴BPRT机组
shaangu 膨胀机斜安装叶片的尺寸误差分析
ketu Antihypertensive treatment and CHD in the elderly (letter)
yiby EQUATIONS OF MOTION FOR TRAIN DERAILMENT DYNAMICS
penggl 公安部队的魔杖-非致命武器就是说:doc_title字段的值有的是中文,有的是英文,我想判断一下中、英文分别多少条。
ELECT * FROM tt WHERE doc_title REGEXP '[^ -~]'