Select different field in mysql if a field is set to null? -

-

I select the displayname as the user name if username = null and if the user name is not null Then select the username as the username. example. 

  id user name name 1 xyz null 2 ​​null aBC

Select how I can do this in a single statement ... Thank you

Collages (user name, vip name) should help you.

Example: 

  The user from selected Coleses (Username, Dzemen) where ...

Comments

Post a Comment

Popular posts from this blog

ios - Form Sheet content disappearing -

-
Image
I am trying to apply a form sheet. Looks like this on the storyboard: App background only when I run Appears and everything else is hidden. I am presenting a form sheet using model sheets - I am working with the form sheet and I (WREGLR Regular) size. Why is this happening?
Read more

Lists in scheme -

-
I am trying to write a function in the plan that takes every item list and class in the list, then returns the list As is (list xyz) . However, I'm not sure how to write a code that would do this. So far, I have (defined (category = list list) (cond [(empty? List) false) [and (list (SQL) (first A-list)) (Square-list) (The rest is a list)))]) but it returns to the list (cons y (cons z empty)) What can I do to return it to the list only in (list xyz) ? Thanks! You're almost there - make sure you type cons and List (The text book explains this section 13. You can find copies online). Conflict The first element for the 'rest' part and (usually) one (potentially empty) list as an example, (Opposition 1 blank) Number 1 as its first element and the empty list is in the form of 'rest' (Opposition 1 (Opposition 2 Empty)) No. 1 before Element, and (Opposition 2 empty) is in the form of 'rest'. List is just a simple shorth...
Read more

c++ - an enclosing-function local variable cannot be referenced in a lambda body unless if it is in capture list -

-
I have the json :: value object and I try to get the value in a straight but I'm about the capture list I get this error in I understand that this bracket holds the [] capture list in the phrase, but I can not understand how I can return a value in the Lambda function? Zero Jasondomain :: Set Value (JSN :: Value OBG) {weather.coord.lon = obj.at (L "Coordination"). (L "longitude") as_double () .; Weather.coord.lat = obj.at (L "Coordinate"). (L "Latitude"). As_double (); } Zero JsonDeneme :: getHttp () {// json :: value val; Http_client Client (U ("http://api.openweathermap.org/data/2.5/weather?q=Ankara,TR")); Client.request (methods :: GET) .then ([] (http_response response) - & gt; pplx :: task & lt; json :: value & gt; {if (response.status_code) == condition_code :: OK ) {Printf ("Received response status code:% u \ n", response.status_code ()); Return response .extract_json ();} return pplx :: task_fro...
Read more