<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I get:-</p>
<p><span style="white-space: pre-wrap">
mysql> select chanid,channum,sourceid,callsign,name,xmltvid,mplexid,serviceid from channel where name like '%prime%' or name like '%sky open%' or callsign like '%prime%' or callsign like '%sky open%' or serviceid=1406 or xmltvid like '%prime%' or xmltvid like '%skyopen%';
+--------+---------+----------+----------+----------+---------------------+---------+-----------+
| chanid | channum | sourceid | callsign | name | xmltvid | mplexid | serviceid |
+--------+---------+----------+----------+----------+---------------------+---------+-----------+
| 10015 | 15 | 1 | Sky Open | Sky Open | prime.freeviewnz.tv | 4 | 1406 |
+--------+---------+----------+----------+----------+---------------------+---------+-----------+
1 row in set (0.01 sec)
</span></p>
</body>
</html>