Search for value corresponding to weight

Question

Search for value corresponding to weight

Navigation

#1 by (5 votes)
#2 by (-1 votes)
#3 by (-1 votes)

2

I have a table with values, where each value is according to weight (kg).

Up to 3kg = $ 20.00

Up to 5kg = $ 25.00

Up to 10kg = $ 28.00

SELECT estado, kg, valorCap, valorExcedCap, valorAloremCap, prazoCap 
  FROM transportadoras_valores 
    WHERE id_transportadora = '1' && estado = 'AL' && kg = '4'

In this example I need to return the value of 5kg.

I have an online example:

link

php mysql select mysqli

asked by anonymous 14.05.2015 / 21:49

3 answers

-1

SELECT estado, kg, valorCap, valorExcedCap, valorAloremCap, prazoCap
    FROM transportadoras_valores 
    WHERE id_transportadora = '1' && estado = 'AL' && kg = '5'

14.05.2015 / 21:58

-1

SELECT estado, kg, valorCap, valorExcedCap, valorAloremCap, prazoCap 
FROM transportadoras_valores 
WHERE id_transportadora = '1' && estado = 'AL' && kg > '3' && kg <= '5')

14.05.2015 / 21:52

how browsing-context works When to use this and when to use event.target

score 5 · Accepted Answer

You can do this:

SELECT estado, kg, valorCap, valorExcedCap, valorAloremCap, prazoCap 
  FROM transportadoras_valores 
  WHERE id_transportadora = 1 && estado = 'AL' && kg >= 4
  ORDER BY kg ASC
  LIMIT 1

In this way you say that you want it to be a single result, the first one to be greater than or equal to the value you passed the query.