Sorting rows by the string beginning with specific letter in MySQL
===

Lets say i have a column bridge_code, which has values as follows

F001
F002
PC10
H001
H001
H003
H234
DCM0

All i want to do is sort above rows so that bridge_code beginning with character "H", comes at first, and rest of the code in descending order. For example i would like to return sorted rows as

H001
H002
H234
DCM0
F001
F002
PC10

Thanks
Sabin
