一个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