[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
我要从上面字符串@开始截取,怎么截取它们都是login字段的我是试论好多方法都不行
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
我要从上面字符串@开始截取,怎么截取它们都是login字段的我是试论好多方法都不行
+---------------------------------------------------------+
| substring('[email protected]',1,INSTR('[email protected]','@')-1) |
+---------------------------------------------------------+
| abc |
+---------------------------------------------------------+
1 row in set
+---------------------------------------+
| substring_index('[email protected]','@',1) |
+---------------------------------------+
| abc |
+---------------------------------------+
1 row in set (0.00 sec)
正解!另外提醒下,你的login不能有2个@,否则这样也错。