select MFILEID as value, CONCAT(MFILEID,' - ',MFILENAME) as dtext,CONCAT('ID: ',MFILEID,' Name: ',MFILENAME,', Pfad: ',MFILEPATH) as title 
  from CCMFILES
 where MFILEID like CONCAT('%',::searchstring::,'%')
    or MFILENAME like CONCAT('%',::searchstring::,'%')
    or MFILEPATH like CONCAT('%',::searchstring::,'%') 
    or MFILEATTRIBS like CONCAT('%',::searchstring::,'%') 