MySQL ORDER BY multiple elements in different where clauses -

-

I have a question for which I do not know how to call it properly. Maybe I do not use the correct name and therefore I could not find the answer.

But it is the case

  • Buking_ Start (Waimdi)
  • Buking_sttaim (H: A database table to me to come): booking_hotelstart (ymd)
  • booking_hotelstart (ymd)
  • booking_hotelstarttime (Ymd)
  • booking_hotelend (ymd) >
  • booking_hotelendtime (h: i)
  • booking_and (ymd)
  • booking_and time (h: i)
  • booking_enable ( Boole)

    Now I want to do a query that is about it: (What I want to do is to show it A invalid question) 

      SELECT `booking_id` to` system_bookings` WHERE ((`booking_start` = '2014 -10-20' order 'booking_stime' ASC) or (` booking_hotelstart `= '2014-10-20' Order 'booking_hotelstarttime' asc) or (` booking_hotel '=' 2014-10-20 'order booking_and time' ASC) or (`booking_and` = '2014-10-20' order booking_and time 'ASC') and `booking_screated` = threshold of truth 0, 100   
     then originally section with one command. But how to do it ?? I have no clue how to find it correctly. So I hope someone can show me some direction, which I should go on. Other than that. I would like to know how it is called. For next searches.  
     Thanx in advance!  
     
      Edit:   
     According to the request I created some sample data:  
      do not create tables `Well system_bookings` (` booking_id` int (6) nOT NULL AUTO_INCREMENT, `booking_start` not on NULL,` booking_starttime` varchar (5) is not NULL, `booking_hotelstart` NULL not on, `booking_hotelstarttime` varchar (5) is not NULL, `booking_hotelend` not on nULL,` booking_hotelendtime` varchar (5) is not nULL, `booking_end` not on nULL,` booking_endtime` varchar (5) is not nULL, `Booking_confirmed` tinyint (1) nULL, pRIMARY KEY ( `Buking_aidi`) ) Engine = InDebbi default charge = latin1 AU TO_INCREMENT = 6; `Putting System_bookings` (` booking_id`, `booking_start`,` booking_starttime`, `booking_hotelstart`,` booking_hotelstarttime`, `booking_hotelend`,` booking_hotelendtime`, `booking_end`,` booking_endtime`, `booking_confirmed`) values ​​(1, '2014-10-09', '21: 19 ',' 2014-10-08 ', '21: 19', '2014-10-23', '08: 00 ',' 2014-10-23 ',' 22: 00 ', 1), (2,' 2014-10-11 ', '16: 00', '2014-10-27', '12: 15 ',' 2014-10-28 ', '17: 45 ',' 2014-10-28 ', '17: 45', 1), (3, '2014-10-10', '20: 30 ',' 2014-10-10 ', '20 : 30 ',' 2014-10-11 ', '08: 00', '2014-10-20', '14: 00 ', 1), (4,' 2014-10-12 ', '20: 00 ',' 2014-10-12 ', '20: 00', '2014-10-13', '05: 00 ',' 2014-10-29 ', '22: 00', 0), (5, '2014-10-22', '15: 00 ',' 2014-10-22 ', '20: 30', '2014-10-23', '04: 15 ',' 2014-10-31 ', '12: 00 ', 1);    
     
     
     You can have several conditions in the  order  section. So, formally, you want it:  
      SELECT `booking_id` Se` system_bookings` where 'Buking_sukunit` = right (` Buking_ start` =' 2014-10-20 'OR' Booking_hotelstart` = '2014-10-20' or `booking_hotel '=' 2014-10-20 'or` booking_and` =' 2014-10-20 ') Order (in case when `booking_start` =' 2014-10-20 And 'then `Buking_sttaim` WHEN` Buking_hotlstart` =' 2014-10-20 'and' Buking_hotlstarttaim` when` Buking_hotlend` = '2014-10-20' then 'Buking_andtaim` WHEN` Buking_and` =' 2014-10-20 ' 'Booking_and time'END) LIMIT 0, 100; However, this is a bit unresponsive, because you are comparing a value for a constant, and then sorting that value. I suspect that you want to give priority to  where  rules and actually want to do something else like this:  
      by order (case when `booking_start` = '2014-10-20' then at 1 a.m. when `booking_hotelstart` = '2014-10-20' then 2 WHEN` booking_hotel '=' 2014-10-20 'then 3 WHEN` booking_and` =' 2014-10-20 ' THEN 4 END)

    • Comments

    Post a Comment

    Popular posts from this blog

    php - PDO bindParam() fatal error -

    -
    I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
    Read more

    php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

    -
    I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
    Read more

    logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

    -
    For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
    Read more