表结构大概是这样的
id name price
1 house1 $100,000
2 house2 $150,000
3 house3 $10,000
4 house4 From $10,000
5 house5 From $100/night
6 house6 From $150/night表名是house
用这个语句
SELECT * FROM `house` ORDER BY `house`.`price` ASC
顺序如下
1 house1 $100,000
2 house2 $150,000
3 house3 $10,000
4 house4 From $10,000
5 house5 From $100/night
6 house6 From $150/night应该怎么写SQL语句
才能输出
5 house5 From $100/night
6 house6 From $150/night
4 house4 From $10,000
3 house3 $10,000
1 house1 $100,000
2 house2 $150,000以price这个字段排序
id name price
1 house1 $100,000
2 house2 $150,000
3 house3 $10,000
4 house4 From $10,000
5 house5 From $100/night
6 house6 From $150/night表名是house
用这个语句
SELECT * FROM `house` ORDER BY `house`.`price` ASC
顺序如下
1 house1 $100,000
2 house2 $150,000
3 house3 $10,000
4 house4 From $10,000
5 house5 From $100/night
6 house6 From $150/night应该怎么写SQL语句
才能输出
5 house5 From $100/night
6 house6 From $150/night
4 house4 From $10,000
3 house3 $10,000
1 house1 $100,000
2 house2 $150,000以price这个字段排序
好吧 我自己解决了~~
又损失积分了
repalce(replace(replace(price,'From $',''),'/night',''),'$','')+0