当前位置：网站首页>Sqlserver determines whether a column in the table contains Chinese, English and pure numbers

Sqlserver determines whether a column in the table contains Chinese, English and pure numbers

2022-04-22 19:23:00 【Pingshan CP3】

background ： A batch of data needs to be updated in batch in the database , The condition is that a column contains Chinese characters .

sql sentence ：select * from table1 where Name like '%[ Acridine - seat ]%'

expand ：

1. The field contains English characters

select * from table1 where Name like '%[a-z]%'

2. The field contains pure numbers

select * from table1 where Name like '%[0-9]%'

版权声明
本文为[Pingshan CP3]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221922242176.html