Please try

SELECT *
FROM `video`
WHERE `channel` LIKE '%|1|%'
LIMIT 0 , 30