ect password from t_users where ascii(left(password,1))=49;
+----------+
| password |
+----------+
| 123456 |
#可以直接擦每一位的值，也可以查acs值，但是直接查值是快些
#这样直到猜完length(password)位为止
#但是中文的名字不好猜啊，1个字，2个字节
>>> int("张")
traceback (most recent call last):
file "", line 1, in
valueerror: invalid literal for int() with base 10: '\xd6\xec'
>>>
>>> chr(66)
'b'
>>>
#其实还是可以查的
mysql> select password from t_users where left(name,1)="张";
+----------+
| password |
+----------+
| 123456 |
+----------+
1 row in set (0.00 sec)
mysql> select password from t_users where left(name,2)="张";
empty set (0.00 sec)
#记住left是返回的所有的左边的值哈
mysql> select password from t_users where left(name,2)="张三";
+----------+
| password |
+----------+
| 123456 |
+----------+
#mid(匹配的字段，从第几个开始，取几个);可以完成逐位比较
mysql> select password from t_users where mid(name,2,1)="三";
+----------+
| password |
+----------+
| 123456 |
+----------+
1 row in set (0.00 sec)
|