Ver originalSELECT campo1, campo2, campo3 FROM comentarios ORDER BY FIELD(profile, 'golden', 'silver', 'bronze', 'free');
Ver originalSELECT campo1, campo2, campo3, IF(profile='golden', 1 , IF(profile='silver', 2, IF(profile= 'bronze', 3 , 4 ) ) ) AS nro_profile FROM comentarios ORDER BY nro_profile ASC;