select name from channel where name LIKE ‘%CNET%’;
The % matches 0 or more characters, if you want to match only one character, you use _
Categories
select name from channel where name LIKE ‘%CNET%’;
The % matches 0 or more characters, if you want to match only one character, you use _