How can (is it possible) to organize a filter by price?

Question

SQL

How is it possible (is it possible?) to organize a filter by price, provided that the cost of the product can be in rubles / dollars / euros, and the user filters the data by one of the currencies. Example, the user is looking for products worth 100 rubles, the database contains products worth $ 100 and 100 euros, the primitive where will find both products, which is not correct. At the moment there are two columns price(int), currency(int).

Answer 1

It is possible, "primitive where" on currency and the price.

Answer 2

join to pull up the exchange rate, and then search by product

Answer 3

Kindest!
Add. question - while filtering, you need to display only products with a price indicated in the "filtered" currency, or in any currency, but taking into account the exchange rate at the time of "filtering"?
As ky0 wrote , you can get by with a simple "where", or you can create a view where prices will be indicated in one currency (with conversion to the exchange rate) and already filter products by this view.