SELECT CONCAT( "" , d.demographic_no, "" ) As "Dem#", CONCAT( "eChart" ) AS "eChart" , DATE( cn.observation_date) as Date, CONCAT( p.first_name , ' ', p.last_name) as provider , d.last_name, d.first_name, TIMESTAMPDIFF (YEAR, concat(year_of_birth,'-',month_of_birth,'-',date_of_birth), CURDATE()) as Age, substr(cn.note,locate( SUBSTRING_INDEX('{search}', ' ', 1) ,cn.note),1000) as FoundNotes from demographic d, casemgmt_note cn, provider p where cn.demographic_no = d.demographic_no and p.provider_no = cn.provider_no and cn.note like replace('%{search}%',' ','{wildcard}') group by cn.note_id, d.demographic_no order by cn.observation_date DESC {limitnumresult} ; OFF ON OFF 1000 10 100 500 ALL