Shulou(Shulou.com)06/01 Report--

The following brings you about mysql how to judge the field is empty content, I believe you must have read a similar article. What's the difference between what we bring to everyone? Let's take a look at the text. I'm sure you'll get something after reading mysql how to judge the field is empty.

Here are five ways to query:

Isnull ()

Select * from users where email = 'xxxx' and isnull (deletedAt)

Is null

Select * from users where email = 'xxxx' and deletedAt is null

Is not null

Select * from users where email = 'xxxx' and deletedAt is not null

! isnull ()

Select * from users where email = 'xxxx' and! isnull (deletedAt) select * from users where email =' xxxx' and not isnull (deletedAt)

Isfull

When the query condition is null, replace it with the specified character

Select name, isfull (gender,' unknown') as gender from users where email = 'xxxx'

Do you think it is what you want about how mysql determines that the field is empty? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.