Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +----+-------+-------+--------------+--------------+
- | id | mood1 | mood2 | mood1_visual | mood2_visual |
- +----+-------+-------+--------------+--------------+
- | 1 | 5 | 7 | 5c | 7a |
- | 2 | 5 | 7 | 5b | 7b |
- | 3 | 5 | 7 | 5c | 7d |
- | 4 | 5 | 8 | 5a | 8a |
- | 5 | 5 | 7 | 5c | 7a |
- | 6 | 5 | 8 | 5b | 8a |
- +----+-------+-------+--------------+--------------+
- (`mood1_visual`='5c' AND `mood2_visual`='7a') OR
- (`mood1`=5 AND `mood2`=7 AND (`mood1_visual`<>'5c' OR `mood2_visual`<>'7a'))
- (`mood1_visual`='5c' AND `mood2_visual`='7a')
- ORDER BY THE ONES THAT MATCH CONDITION FIRST THEN THE OTHERS ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement