mysql select query

[pingham]

I am using
$query=mysql_query ("SELECT * from XXX WHERE XXX ='ampthill' ORDER by XXX ASC");
to select my data from mysql. I would like to display members data above all other data and then the rest ASC. members are identified with a 'yes' or 'no' in a members columb. Any ideas?

[Kid Charming]

SELECT
foo
FROM
bar
WHERE
x = 'string'
ORDER BY
CASE membercol
WHEN 'yes' THEN 0
ELSE 1
END
ASC
,othercol
ASC