select sql_calc_found_rows b.seq, b.category as name, b.title, date_format(date_format(b.senddate,'%Y%m%d'),'%Y-%m-%d') as dis_date, b.senddate as reg_date from news_data b where case when length(trim('')) = 0 then 1 else case '' when 'all' then lower( concat(b.category,' ',b.title,' ',b.body)) when 'name' then lower(b.category) when 'title' then lower(b.title) when 'content' then lower(b.body) end like lower(?) end order by b.senddate desc, b.sendtime desc limit 0,15 MDB2 Error: not supported