CODEWITHSUNDEEP
phpmysqlsql
Genci
Genci

Reputation: 33

SQL query, by comparing values

I have a form where you have to input the ammount to deposit (number), and a mysql table where it has a list of banks with the minimal ammount of deposit (like first row = name, second row = minimal amount).

The question is: How can i query the database in order to show me the banks which are right for me according to minimal deposit value? So example you want to deposit 50$, but not all banks allow you this as some of them have 100$ minimal deposit, so i want to show only those that have min.deposit below my amount.

Upvotes: 0

Views: 83

Answers (1)

John Woo
John Woo

Reputation: 263723

add a WHERE clause in your query as it will filter the records according to your needs,

SELECT *
FROM tableName
WHERE minimalAmount <= 50

Upvotes: 1

Related Questions