数据库结构如下CREATE TABLE `ecm_tixian` (
`id` int(50) NOT NULL auto_increment,
`user_name` varchar(50) character set gbk NOT NULL,
`jifen` varchar(50) character set gbk NOT NULL,
`money` varchar(50) character set gbk NOT NULL,
`bank` varchar(50) character set gbk NOT NULL,
`bankid` varchar(50) character set gbk NOT NULL,
`addtime` varchar(50) character set gbk NOT NULL,
`beizhu` varchar(50) character set gbk default NULL,
`nbbeizhu` varchar(50) character set gbk default NULL,
`admin` varchar(50) character set gbk default NULL,
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;INSERT INTO `ecm_tixian` VALUES (3, 'vipstar', '60', '6', '中国工商银行', '9558800407110888888', '1281015222', '测试这是备注', '这是一个内部备注', 'admin');
我使用sql语句
SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%admin%'可以查询出结果,但SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%95588%'SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%vipstar%'
后面这2条SQL都查不出结果来,为什么呢,,
`id` int(50) NOT NULL auto_increment,
`user_name` varchar(50) character set gbk NOT NULL,
`jifen` varchar(50) character set gbk NOT NULL,
`money` varchar(50) character set gbk NOT NULL,
`bank` varchar(50) character set gbk NOT NULL,
`bankid` varchar(50) character set gbk NOT NULL,
`addtime` varchar(50) character set gbk NOT NULL,
`beizhu` varchar(50) character set gbk default NULL,
`nbbeizhu` varchar(50) character set gbk default NULL,
`admin` varchar(50) character set gbk default NULL,
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;INSERT INTO `ecm_tixian` VALUES (3, 'vipstar', '60', '6', '中国工商银行', '9558800407110888888', '1281015222', '测试这是备注', '这是一个内部备注', 'admin');
我使用sql语句
SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%admin%'可以查询出结果,但SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%95588%'SELECT * FROM `ecm_tixian` WHERE CONCAT('user_name','money','bank','bankid','beizhu','nbbeizhu','admin') like '%vipstar%'
后面这2条SQL都查不出结果来,为什么呢,,
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货