Question about MySQL query

[tnuriel]

If anyone out there is good at MySQL queries, please help me out.
Basically, I'm playing with a custom php file, and the file uses a query to select from the video table in MySQL ($query = "SELECT * FROM video WHERE type =...)
I would like to qualify this request so that it just selects videos from a specific channel.
Unfortunately, this becomes more complicated because the "channel" id in the video table is usually something like this: 0|1|23|0. But all I want to specify is the 1, not the whole thing.
Does anyone know how I would do this????

[buyscripts]

Please try

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