[RESOLVED] if statement in sql query

[cbesh2]

I currently have a MySQL query similar to the following:

SELECT * FROM People ORDER BY lname, familyrole, gender, birthday

However, the data is not what I need.

I would like the following:

if $familyrole = "Head of Household" -  I want the order to be by gender
if $familyrole = "Non-Head of Household" - I want the order to be by birthday.

Any suggestions? Thanks for you help in advance.

[Sxooter]

cbesh2 wrote:

I currently have a MySQL query similar to the following:

SELECT * FROM People ORDER BY lname, familyrole, gender, birthday

However, the data is not what I need.

I would like the following:

if $familyrole = "Head of Household" -  I want the order to be by gender
if $familyrole = "Non-Head of Household" - I want the order to be by birthday.

Any suggestions? Thanks for you help in advance.

select * from people
order by
lname,
case when familyrole='Head of Household' then gender
else birthday
end

[cbesh2]

Excellent! I knew there had to be a way. Thank you so much!

[Sxooter]

You're welcome. Case is a really useful bit of kit, eh?