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