/**
  only update columns when values not empty
 */

UPDATE 
 `text` 
 
SET 
	`name` = CASE WHEN :name <> '' THEN :name ELSE `name` END,  
	`site` = CASE WHEN :site <> '' THEN :site ELSE `site` END,  
	`category` = CASE WHEN :category <> '' THEN :category ELSE `category` END,  
	`country` = CASE WHEN :country <> '' THEN :country ELSE `country` END,  
	`lang` = CASE WHEN :lang <> '' THEN :lang ELSE `lang` END,  
	`grid` = CASE WHEN :grid <> '' THEN :grid ELSE `grid` END   
 
WHERE 
 `ID` = :ID
