MYSQL IF Statement

[p3mbo]

Hi,
I'm having slight trouble with one of my SQL statements im trying to complete.... the statement is

SELECT * FROM seasons
WHERE end >= $num
AND start <= $num

What I want to do, is something like this...

SELECT * FROM seasons
IF (start > end)
{
WHERE end <= $num AND start <= $num
}
else
{
WHERE end >= $num AND start <= $num
}

But I can't figure out how to do it in SQL...

Any help is greatly appreciated...

[LordShryku]

SELECT * 
  FROM seasons
 WHERE IF(start > end, end <= $num, end >= $num)
   AND start <= $num

[Sxooter]

Look up the "case" construct. It's ANSI SQL standard, and does exactly what you're trying to do.

[p3mbo]

Thanks for all your help, I've now managed to get it working thanks to the first post.