首页 › KO技术综合区「KO. PROGRAM」 › 批量查找含有特殊字符的帐号--SQL

ctgwglzc 发表于 2009-9-15 08:09:16

批量查找含有特殊字符的帐号--SQL

select * from tb_user where
straccountid not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''
and strAccountID not like ''

ctgwglzc 发表于 2009-9-15 08:13:16

作用：
可一次性查找含有字母和数字之外字符的帐号

wang9898 发表于 2009-9-19 00:59:21

本帖最后由 wang9898 于 2009-9-19 01:00 编辑

和攻击有关？如果是最好设法不让玩家注册的帐号或者密码还有角色名称带有特殊字符

查看完整版本: 批量查找含有特殊字符的帐号--SQL