select * from A order by 
  case Name when 'wind' then 1
      When 's'   then 2
      when 't'   then 3
  end ASC

就是在Order by 后面加个case when