The following is actually a simplified version of the SQL I am trying to run
SELECT ID, summary, IFNULL(image,0) as mee FROM memoblog WHERE (lcase( concat(cast(ID as
char), summary, image)) LIKE '%yoo%' )
If any of the columns are NULL the whole thing will be considered NULL. I would like to give "image" a value that is close to NULL without invalidating the whole query. I'm still seeing what I can find. It seems like every example I try from other sites just won't work.