[SOLVED] if in query?

[Norsk.Firefox]

Hello

Is it any way possible to use if's in a query?

example:

SELECT `f`.`status AS `status`, `u`.`name` FROM `friends` AS `f`, `users` AS `user` WHERE (`f`.`id` = 1 OR `f`.`id2` = 1) AND `u`.`id` = `f`.`id`

 

What i want is to have "`u`.`id` = `f`.`id` or `id2`, and the id field from friends should be picked where the id field is not like 1.

In php I would have done it like this if it's not possible in sql:

<?php
$sql = mysql_query("SELECT `id`, `id2`, `status` FROM `friends` AS `f` WHERE `id` = 1 OR `id2` = 1");

while($row = mysql_fetch_array($sql)) {
  if($row['id'] == 1)
    $sql2 = mysql_query("SELECT * FROM `users` WHERE `id` = ". $row['id2']);
  else 
    $sql2 = mysql_query("SELECT * FROM `users` WHERE `id` = ". $row['id']);
  echo mysql_result($sql2, 0, 'name')
}
?>

But this solution would take to much resources. So any other solution?

 

Solution: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if