order by 
  CASE @order
    WHEN 'name' THEN lastname
    WHEN 'state' THEN state
   END,
  CASE @order
    WHEN 'name' THEN firstname
  END,
  CASE @order 
      WHEN 'user_id' THEN user_id
  END