基于邮政编码计算邮资费用

Question

I am looking to find a way to calculate the cost of Postage based on Postcodes entered into a Form - I am looking at having the prices stored in a database possibly like for example: Postcode is 4000 to 4999 postage will be $8.00 or Postcode is 2000 to 2999 postage will be $4.65 Would it be if, if/else??? if/ or??? Not sure... Thanks in advance

Answer 1

Try CASE https://www.w3schools.com/sql/func_mysql_case.asp

Something like this:

SELECT   Postcode, Cost =  
      CASE 
         WHEN Postcode LIKE '4%' THEN 8.00  
         WHEN Postcode LIKE '2%' THEN 4.65   
         ELSE 'unknown'  
      END

or

    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