select * from gy_jbbm where regexp_substr(jbmc,'[0-9]+') is not null 转载于:https://www.cnblogs.com/thomasbc/p/10952033.html