I have:
(int) date [timestamp]
(varchar) start
(varchar) end
where 'start' and 'end' are something like "1:30 pm" "10:00 pm" "08:00 am"
Sometimes it may say something different like "TBA" or "N/A" or "blahdeblah." (So like I said, varchar is what I really want)
NOW.... how might I sort these within the query? Because ORDER BY `date` ASC, `start` ASC doesn't work... It thinks 8 is > 2, so 2pm comes before 8am.
I know I can run a custom sort that uses strtotime(), but I'd rather do this in the query if possible. Is there a way to either sort times or cast the time into a timestamp?
really bad example of what I mean:
ORDER BY MAKETIME(`start`) ASC; [or MAKETIME(`date`+`start`)]??