Why not just

select m_category from table 
where INSTR(m_category,'|44|') > 0 
or SUBSTRING(m_category,0,3) = '44|'
or SUBSTRING_INDEX(m_category,'|',-1) = '44';
[download]

-Jason update: changed to accomodate 44 as the first or last column