Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > MySQL IFNULL query

MySQL IFNULL query

大家讲道理
Release： 2016-11-12 09:55:37
Original
1346 people have browsed it

SELECT * FROM 用户表 ORDER BY IFNULL(nickname, realname);
 
SELECT IFNULL(NULL,10); -- > 10
Copy after login

Related labels：
代码片段，代码分享，PHP代码分享，Java代码分享 Ruby代码分享，Python代码分享，HTML代码分享，CSS代
source：php.cn
Previous article：Multiple ways to change root password in MySQL Next article：SQL SERVER calculates distance function based on map longitude and latitude
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
Parent's padding ignored by sticky positioned child How to prevent sticky elements from going behind the header? The current code snippet uses...
From 2024-04-06 11:42:51
0
1
338
How to know when a Vue component is fully initialized? So, in my Vue component, I have an async created method and several variables with async w...
From 2024-04-05 14:20:24
0
1
1442
The restated title is: The English translation of Stripe Connect Subscription Split Fees is "Stripe Connect Subscription Split Fees" Hi, I'm building a platform for clients using StripePHPAPI that sells subscriptions on a m...
From 2024-04-02 20:15:22
0
1
418
How to align images using CSS grid? I'm trying to build part of a website using CSS grid. I'm trying to get the list and image...
From 2024-04-01 22:08:31
0
1
338
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template