[Resolved] Specific SELECT statement

[datona]

Does anyone know how to produce ONE query. Something like:

SELECT * from TABLE where ID = '263' OR where lastname = 'Simpson'

BUT what I want it to do is pull the ID out first and then display all that has the lastname = 'Simpson'

I need to do this all in ONE query due to the fact that I am creating arrays AND also counting the number of results. Sorry it is hard to explain but that gives you an idea as to what is troubling me.

Thanks in advance to anyone that can help.

[autocolismo]

SELECT * from TABLE where ID = '263' OR lastname = 'Simpson'

[datona]

Thanks...That works BUT how can I get it so it will display the line where id=263 first, then all with lastname = Simpson.
I need it to have the first line being the ID=263

[liquorvicar]

SELECT * from TABLE where ID = '263' OR lastname = 'Simpson' order by ID='263' desc,lastname='Simpson' desc

[datona]

Liquorvicar, THANK YOU!!!

That works perfectly!!!