v5:reference:connection:ifnull
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
reference:ifnull [2015/07/20 13:53] – [Usage] mnewnham | reference:ifnull [2015/11/24 16:00] – [Description] mnewnham | ||
---|---|---|---|
Line 8: | Line 8: | ||
</ | </ | ||
===== Description ==== | ===== Description ==== | ||
- | The function '' | + | The function '' |
- The field in the table to check. | - The field in the table to check. | ||
Line 21: | Line 21: | ||
/* | /* | ||
- | * ifnullString returns 'CASE WHEN pants_field is null THEN ' | + | * ifnullString returns 'CASE WHEN pants_field is null |
+ | | ||
+ | | ||
+ | | ||
*/ | */ | ||
- | $SQL = " | + | $SQL = " |
+ | SET pants_field = $ifNullString"; | ||
$db-> | $db-> | ||
</ | </ |
v5/reference/connection/ifnull.txt · Last modified: 2016/01/16 23:34 by mnewnham