假如一个字段中有要能在查询的时候计算出他们的值
sql语句写法:
select round((left(size,POSITION('×' IN size)-1))*substring(size,POSITION('×' IN size)+1),2) as sizetotal from art limit 0,1
假如一个字段中有要能在查询的时候计算出他们的值
sql语句写法:
select round((left(size,POSITION('×' IN size)-1))*substring(size,POSITION('×' IN size)+1),2) as sizetotal from art limit 0,1