complicated (?) sql Statement

[datona]

I am attempting to search a MySQL dbase for variables and show in a specific order.

The database is something like:

ID | Customer Name | Vehicle | Type | TOP3

1, Frank finny, Toyota Camery, car, 1
2, frenchy , Chevy Nova, car, 1
3, Dave Macey, Ford F150, truck, 0
4, Lisa B, Ford Taurus, car, 1

and the list goes on......but
What I need to do is display this in order by 'TOP3' (display all that are TOP3 first) and then all the rest BUT (and this is the brain scartcher) I need to ALWAYS have it come up with Lisa B (4) come up on the list first.

This is the SQL statement and it works to a point:
SELECT * FROM 'clients' ORDER BY TOP3 DESC, rand()

What this does is display all that are TOP3 like 1, 2, and 4 BUT I want '4' to be displayed first. Number 4 is NOT the end of the list in the database, I want number '4' to always be the first to be displayed.

Thanks for any help!!!! 😕

[tunage]

Not tested it but i think this should work -

SELECT * FROM 'clients' ORDER BY TOP3 = '4' DESC, TOP3 DESC

[datona]

Thank you Tunage.....That did the trick!
😃