大家看看图吧,直接输入详细的数字是可以查询的,用通配符就查询不到,不知何故。
真心求助大家帮忙解决决一下。。http://b61.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f0108cf273b28fdfbbb17e7066548b097be8d9edcc54969a7d42901d1c51df4e4badc1b2ed501df7f8b977532665d5e64d5a4fd88b2a41482b5d66b0e1b1c5c03efa1058c&a=65&b=61
http://b66.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f8ad836fd2a524e82bce2caa244f49f5d7318e4d7d382204825f0d99c346a3d843e52abee0cdfb83f1a3f67e02fe2263633f612a9e1f92064eeffcbac93252285c59fb197&a=66&b=66
http://b70.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7fd3d992e36fb70f70bbb5cc1402a80e860c22190bc25e6d37cd9e75700aca5a9d8a921bb19b36fac915507caaabc20b46e6b6617547dafdd96740aad7a9403ecc54300c9d&a=57&b=70
http://b61.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f0108cf273b28fdfbbb17e7066548b097be8d9edcc54969a7d42901d1c51df4e4badc1b2ed501df7f8b977532665d5e64d5a4fd88b2a41482b5d66b0e1b1c5c03efa1058c&a=65&b=61
真心求助大家帮忙解决决一下。。http://b61.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f0108cf273b28fdfbbb17e7066548b097be8d9edcc54969a7d42901d1c51df4e4badc1b2ed501df7f8b977532665d5e64d5a4fd88b2a41482b5d66b0e1b1c5c03efa1058c&a=65&b=61
http://b66.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f8ad836fd2a524e82bce2caa244f49f5d7318e4d7d382204825f0d99c346a3d843e52abee0cdfb83f1a3f67e02fe2263633f612a9e1f92064eeffcbac93252285c59fb197&a=66&b=66
http://b70.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7fd3d992e36fb70f70bbb5cc1402a80e860c22190bc25e6d37cd9e75700aca5a9d8a921bb19b36fac915507caaabc20b46e6b6617547dafdd96740aad7a9403ecc54300c9d&a=57&b=70
http://b61.photo.store.qq.com/http_imgload.cgi?/rurl4_b=9c098c9e5e87260b7f4523e47c9b2b7f0108cf273b28fdfbbb17e7066548b097be8d9edcc54969a7d42901d1c51df4e4badc1b2ed501df7f8b977532665d5e64d5a4fd88b2a41482b5d66b0e1b1c5c03efa1058c&a=65&b=61
where sensorid like '%1%'--查询含有1的sensorid 记录
LIKE '[_]n' 表示 _n
LIKE '[a-cdf]' 表示 a、b、c、d或f
LIKE '[-acdf]' 表示 -、a、c、d或f
LIKE '[ [ ]' 表示 [
LIKE '[ ] ]' 表示 ]
LIKE 'abc[_]d%' 表示 abc_d开头的字符串(包括abc_d)
LIKE 'abc[def]' 表示 abcd、abce或abcf
通配符[^][^]用来查询不属于指定范围 ([a-f]) 或集合 ([abcdef]) 的任何单个字符。
如:select * from alluser
where username like 'M[^abc]%'
表示从表alluser中查询用户名以M开头,且第二个字符不是a,b,c信息.