MySQL if/elseif/else statements

[The Little Guy]

I have never tried this before, but can if/elseif/else statements (or something similar) somehow be placed in a MySQL SQL query? If so, could I get an example of how it would be done?

[jsladek]

You can use the if elseif else and write the sql in each one.

if ( $x == $x) { $sql = "SELECT * FROM tableA"; } elseif ($x == $y) { $sql = "SELECT * FROM tableB"; } else {$sql = "SELECT * FROM tableC"; }

-John

[The Little Guy]

That way takes too much time, I would like something like this:
[CODE]
IF search_condition THEN statement_list
    [ELSEIF search_condition THEN statement_list] ...
    [ELSE statement_list]
END IF
[/CODE]
It would be nice if I could get an example of that though.