一个mysql语句的写法? select *, floor(case itemcategory when like '%xx' then itemcategory/1 else itemcategory/100 end) as category from item 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select *, floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100 end) as category from item try:select *, floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100 end) as category from item select *, floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100 end) as category from item select *,floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100end) as categoryfrom item 请问如果mysql服务无法启动,如何从安装目录中的数据文件恢复数据库? 数据库新手问下有关Mysql数据类型的问题,求大神解答~~ mysql 子查询 having为空问题 面试题目,这个大表如何设计呢? mysql查询 求救个mysql存储过程的问题 mysql select的怪问题 Mysql不能创建新数据库及新表 请问mysql几种版本的区别在什么地方? 关于MYSQL的错误 Mysql有没有直观点的界面操作的工具? 如何备份整个mysql数据库?
floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100 end) as category
from item
select *, floor(case when itemcategory like '%xx' then itemcategory/1 else itemcategory/100 end) as category
from item
from item