[SQL ] SQL+一些PHP的查詢問題
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
→
02/15 17:07, , 1F
02/15 17:07, 1F