How can I make a custom order where I sort the rows by NAME where the first rows’ name has Bob in it followed by rows with name of Alex in it?
To explain what exactly I mean: I have made the following query to sort result if NAME = ‘Bob’ and if NAME = ‘Alex’:
This HAS to be a PEBCAK problem as it seems so basic. Is there a query to say, “If ‘mon’ = 1 THEN ORDER BY ‘time’ THEN if ‘tue’ = 1 ORDER BY ‘time’, THEN if ‘wed’ = 1 ORDER BY ‘time’” ?
My MySQL query
I’m having a strange problem with the following query:
For example, I have this data in column number: M1, M2, ... M9, M10, U1, U2. In the MySQL query I have: ORDER BY number ASC, but the order display as: M1, M10, M2 ... U1, U2. What can I do to make the order as follows: M1, M2, ... M9, M10, U1, U2? Is this possible?
I have a table titled meetings managing the number of times an employee has been marked present for attending meetings for a range of dates. Table is just e_id and Date. If I have 50 Dates 2021-09-30, 2021-09-29… and an employee has been marked present 7 times in the table during the last 10 scheduled meetings, I am trying to show how many times the employee has been present for the last 10 meetings to determine a trend. For example, my query would look up the employee ID and display 7 for the example above. This is not working. I may have a typo. MYSQL states #1054 – Unknown column ‘e_id’ in ‘field list’. Any help would be appreciated.
How can I get combined order by results retrieved from these two queries joined by a UNION?
I have a table called ‘scorelist’ with the following results:
I have the following database
I have a requirement to sort the records based on “status” field value( running, upcoming, closed ) order and one more condition is like it should be based on date.
