I'm trying to get MySQL to switch assigned key values of a column based. There problem is that value 'capacity' isn't always assigned
Currently I have something like this
IF (m3.meta_key = 'capacity', m3.meta_key = 'capacity', m3.meta_key = 'dimensions')
The problem is that after about 20 rows is defaults to 'dimensions' instead of checking for 'capacity' again. My guess is that its because it doesn't re-que the IF again. The only way I can think of doing this is moving something to the Select portion where it applies this check on a per row statement.