一个mysql语句的写法?
select *, floor(case itemcategory when 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
------解决方案--------------------
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