Mysql IF statement THEN JOIN

Databases
1

Hey i’m writing a script at the moment and i need to write a query which will work like this

SELECT * FROM table
IF table.field_1 = ‘somthing’
LEFT JOIN another_table
ON table.field_2 = another_table.field_1
ELSE IF table.field_1 = ‘somthing_else’
LEFT JOIN another_table_2
ON table.field_2 = another_table_2.field_1
END IF
WHERE table.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.

Thanks

2

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.

3

Got it working now, Cheers :slight_smile:

4

Hi Martian,

Can you post your query which works coz I have the same problem and did try it with outer join…but it isnt working…

cheers:confused: