I want to say in mysql that if a field is NULL, then ignore it … in a select query statement like this -
$result = mysql_query("SELECT
id,
head,
IF(blurb IS NULL, SUBSTRING(story, 1, (locate( ',', story, 50)))) AS blurb, etc etc
Is there a way, please, Experts?
$result = mysql_query("SELECT
id,
head,
IF(blurb IS NULL, SUBSTRING(story, 1, (locate( ',', story, 50)))) AS blurb, etc etc
Is there a way, please, Experts?