小白求助,sql查询时,按照字符串内的数字排序,在线等,MYSQL 5.5.8
寂灭狂龙 2011-11-20 12:22:25 表结构大概是这样的
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这个字段排序