Hey i'm writing a script at the moment and i need to write a query which will work like this
SELECT * FROM
field_1 = 'somthing'
field_1 = 'somthing_else'
field_3 = 'keyword'
I hope that makes sense. I've never used IF statements in mysql before and i can't find much documentation that helps.
I don't think you can do that. What you CAN do is outer join all the tables you might need, and use conditionals in the column list to do whatever you were trying to do here.
Got it working now, Cheers
Can you post your query which works coz I have the same problem and did try it with outer join...but it isnt working...