作者pinkden (丹爷)
看板Database
标题[SQL ] SQL+一些PHP的查询问题
时间Wed Feb 15 15:10:55 2012
TABLE1
+---------+---------+---------+
| column1 | column2 | column3 |
+---------+---------+---------+
| 285 | 178 | 214 |
| 351 | >214 | 489 |
| >312 | 734 | 934 |
| 1090 | 400 | >545 |
| 890 | 2669 | 1779 |
| 200 | 800 | 1138 |
+---------+---------+---------+
<select name="columnchose">
<option value="column1">column1</option>
<option value="column2">column2</option>
<option value="column3">column3</option>
</select><p>
结果小於 <input name="value" type="text" size="10" /><p>
<input type="submit" value="送出" />
-------------------------------------------------------------
希望在选单中选取一个column名称後，再输入一个value，
让输出结果是选择的column中小於value的值，
例如，选择column1，value输入500
得到 +---------+
| column1 |
+---------+
| 285 |
| 351 |
| >312 |
| 200 |
+---------+
选择column2，value输入500
得到 +---------+
| column2 |
+---------+
| 178 |
| >214 |
| 400 |
+---------+
请问这个语法该如何写呢?
$columechose=$POST['columechose'];
$value=$_POST["value"];
$sql="Select*,
CAST(
IF(SUBSTRING('TABLE1.*', 1, 1) BETWEEN '0' AND '9',
'TABLE1.*' ,
SUBSTRING('TABLE1.*' , 2)
)
AS SIGNED) AS columnclean
, 'TABLE1.*' '
From TABLE1
Where columnclean < '$value'";
我是这样子写的，可是查全出的绝过不完全正确
恳请板上各位高手赐教，谢谢~
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.135.120.167
1F：→ hukhuk:SELECT column1 from TABLE1 where column1 < 500 ; 02/15 17:07