Update Mysql except when field not null

by

Use the IS operator to compare with NULL

update your_table
set some_field = 'some value'
where some_field is not null

Using = NULL will not work since comparing with null results in unknown which is not TRUE.

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Math Symbol From Mysql To HTML? [closed]
  3. Create the timestamp of an hour ago [duplicate]
  4. How to convert the json image url string into Bitmap image to display images in android application
  5. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  6. How to use multiple databases in Laravel
  7. How to store repeating dates keeping in mind Daylight Savings Time
  8. Using a .php file to generate a MySQL dump
  9. Insert Blobs in MySql databases with php
  10. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [duplicate]
  11. PDO with INSERT INTO through prepared statements [closed]
  12. How do I execute PHP that is stored in a MySQL database?
  13. MySQL returns only one row
  14. Populate a Drop down box from a mySQL table in PHP
  15. Error while sending QUERY packet
  16. How to sort rows of HTML table that are called from MySQL
  17. Doing a while / loop to get 10 random results
  18. PDO fetch one column from table into 1-dimensional array
  19. php file upload, how to restrict file upload type
  20. Get all mysql selected rows into an array
  21. Select from mysql table WHERE field=’$array’?
  22. Warning: mysql_num_rows() expects parameter 1 to be resource, object given [duplicate]
  23. MySQL error when inserting data containing apostrophes (single quotes)?
  24. php password_verify() hash and pass won’t match
  25. MySQL query using an array [duplicate]
  26. Using MySQL’s TIMESTAMP vs storing timestamps directly
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. Is mysql_real_escape_string enough to Anti SQL Injection?
  29. How to make mysqli connect function?
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment