Classer une string

select *  from my_table where heure between 8 and 14 AND date ="2015-05-15" ORDER BY (CONVERT(SUBSTRING_INDEX(heure,'H',1),UNSIGNED INTEGER)  );

ORDER BY (TIME_FORMAT(CONCAT(substring_index(heure,'H ',1), ':', substring_index(heure,'H ',-1) ), '%H:%i')) asc;

select   CONCAT(T.heure, "H",T.minutes) as HeurMin 
           , T.*
FROM my_table  T
WHERE heure between 8 and 14 
AND date ="2015-05-15" 
ORDER BY heure,minutes

Discussions similaires