有一个mysql表为sbzr 其中有价格price 名称tile 字段 如何列出某一个价格段的数据,比如要列出1-10的数据,我是样的,但是不是正确,请帮忙。 [ecmsinfo]"select * from phome_ecms_sbzr where tmprice between 0 and 10 order by order desc limit 8",8,8,0,24,27,0[/ecmsinfo] 列出中文数据 [ecmsinfo]"select * from phome_ecms_sbzr where title like '%[!a-z]%' order by order desc limit 8",8,8,0,24,27,0[/ecmsinfo] 列出英文数据 [ecmsinfo]"select * from phome_ecms_sbzr where title like '%[a-z]%' order by order desc limit 8",8,8,0,24,27,0[/ecmsinfo] 以上都不正确
|