SELECT t.thedate as "Date", CONCAT( "",demo.demographic_no,"" ) AS "eChart" , t.thesubject as "Subject", t.themessage as "Message", CONCAT(demo.last_name,", ",demo.first_name) as "Patient" FROM messagetbl t JOIN msgDemoMap m ON t.messageid = m.messageID JOIN demographic demo ON m.demographic_no = demo.demographic_no WHERE (NOT LENGTH(TRIM("{num}")) OR m.demographic_no = "{num}") AND (t.themessage LIKE "%{searchword}%" OR t.thesubject LIKE "%{searchword}%" ) ORDER by t.thedate DESC