Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

How to make WHERE col LIKE '%' select NULL values too?

When we apply LIKE keyword to any query then it doesn't return NULL values, and sometimes it required to return NULL values as well. We can do this by using IS NULL or IFNULL operator. Example: We have a table "employee" as be...

What is NULL value in MySQL?

When we don't define any data for a column then the column holds the NULL value. In MySQL, NULL values are used to represent data that is missing. NULL Values If you have created a table with optional columns then you can insert and update ...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: