select * from x_ziyuan where zy_zhanghu regexp '^[0-9]+$' 转载于:https://www.cnblogs.com/crystaltu/p/7151294.html