我正在寻找一种方法来计算邮资成本的基础上，邮政编码输入到一个表格-我正在寻找一个存储在数据库中的价格可能像例如：邮政编码是4000至4999邮资将是8.00美元或邮政编码是2000至2999邮资将是4.65美元如果，如果/否则？？？如果/或？？？不确定。。。提前谢谢
mklgxw1f1#
审判案件https://www.w3schools.com/sql/func_mysql_case.asp像这样：
SELECT Postcode, Cost = CASE WHEN Postcode LIKE '4%' THEN 8.00 WHEN Postcode LIKE '2%' THEN 4.65 ELSE 'unknown' END
SELECT Postcode, Cost =
CASE
WHEN Postcode LIKE '4%' THEN 8.00
WHEN Postcode LIKE '2%' THEN 4.65
ELSE 'unknown'
END
或
SELECT Postcode, Cost = CASE WHEN Postcode BETWEEN '1000' AND '1999' THEN 8.00 WHEN Postcode BETWEEN '2000' AND '2999' THEN 4.65 ... ELSE 'unknown' END
WHEN Postcode BETWEEN '1000' AND '1999' THEN 8.00
WHEN Postcode BETWEEN '2000' AND '2999' THEN 4.65
...
1条答案
按热度按时间mklgxw1f1#
审判案件https://www.w3schools.com/sql/func_mysql_case.asp
像这样：
或