sql 字段记录里有中文和英文,数字数据我怎么查非英文的数据

Question

sql 字段记录里有中文和英文,数字数据我怎么查非英文的数据

Answer 1

"41名人"
"42名人"
"ABDUL KARIM ARULHOSSAIN"
"Phillip Stepney"
"Richard C. Blum"
"Sergio Rossi"
"SIU.WANSUM"
"Usha Mittal"
"WANG TAO"
"William S. Price III"
"丁一"
"丁二"
"丁是"
"丁啊南"
"丁额"
"丁的"
"丁一"
"丁二"
"丁是"
"丁啊南"
"丁额"
"丁的"
"丁一"
"丁二"
"丁是"
"丁啊南"
"丁额"
"丁的"
"丁一"
"丁二"
"丁是"
"丁啊南"
"丁额"
"丁的"
...
还有很多中文的
要求不要英文开头的数据

Answer 2

select * from table1 where name regexp '^[1-9A-Za-z]]';

Answer 3

select * from table1 where name not regexp '^[1-9A-Za-z]]';
 少写个NOT。幸亏被你看出来了。 

Answer 4

mysql> select * from t_cryst2l;
+-------------------------+
| name                    |
+-------------------------+
| 41名人                  |
| 42名人                  |
| ABDUL KARIM ARULHOSSAIN |
| Phillip Stepney         |
| Richard C. Blum         |
| Sergio Rossi            |
| SIU.WANSUM              |
| Usha Mittal             |
| WANG TAO                |
| William S. Price III    |
| 丁一                    |
| 丁二                    |
| 丁是                    |
| 丁啊南                  |
| 丁额                    |
| 丁的                    |
| 丁一                    |
| 丁二                    |
| 丁是                    |
| 丁啊南                  |
| 丁额                    |
| 丁的                    |
| 丁一                    |
| 丁二                    |
| 丁是                    |
| 丁啊南                  |
| 丁额                    |
| 丁的                    |
| 丁一                    |
| 丁二                    |
| 丁是                    |
| 丁啊南                  |
| 丁额                    |
| 丁的                    |
+-------------------------+
34 rows in set (0.06 sec)mysql> select * from t_cryst2l where not name regexp '^[1-9A-Za-z]';
+--------+
| name   |
+--------+
| 丁一   |
| 丁二   |
| 丁是   |
| 丁啊南 |
| 丁额   |
| 丁的   |
| 丁一   |
| 丁二   |
| 丁是   |
| 丁啊南 |
| 丁额   |
| 丁的   |
| 丁一   |
| 丁二   |
| 丁是   |
| 丁啊南 |
| 丁额   |
| 丁的   |
| 丁一   |
| 丁二   |
| 丁是   |
| 丁啊南 |
| 丁额   |
| 丁的   |
+--------+
24 rows in set (0.00 sec)mysql>