Compare values using SQL

Navigation
0


I find myself in the following picture situation

I need via sql to compare the value of the property with the minimum and maximum filter value but due to the semicolons I do not get results. How can I fix this?

    
asked by anonymous 13.04.2018 / 16:23

1 answer

1

You can use MySQL Replace

link 

SELECT <CAMPOS> FROM <TABELA>
WHERE CAST(REPLACE(REPLACE(CAMPO, '.', ''),',','.') as DECIMAL(10,2)) 
       BETWEEN MINIMO AND MAXIMO
    
13.04.2018 / 16:27
Error checking radio with if Form data is not sent to the database