I have a table which stores states of user search. It looks like this:
id | user_id | option | condition | value
------------------------------------------
4 | 2 | price | >= | 300000
5 | 2 | price | <= | 900000
6 | 4 | status | = | 1
7 | 4 | type | = | 1
8 | 5 | price | >= | 100000
9 | 5 | price | <= | 125000
10 | 5 | status | = | 2
11 | 5 | type | >= | 2
13 | 6 | price | >= | 200000
14 | 7 | price | >= | 500000
18 | 8 | price | <= | 600000
------------------------------------------
Now, I need to get all user_id where price value of 400000 fits any condition range (per user), OR status matches 1.
So, for this query, the result should be 2,4,6,8.
Any suggestions are welcome!
Aucun commentaire:
Enregistrer un commentaire