[mythtv-users] Help w/DB error with mythrename since adding .avi's into Recordings

[Mike Holden]

Bobby Gill wrote:
> mysql> select * from recorded where chanid IS 44;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '44' at line 1

"IS" is only valid as a comparison operator for the "NULL" special value.
Otherwise, use a simple good old "=" sign:

    select * from recorded where chanid = 44;

-- 
Mike Holden

http://www.by-ang.com - the place to shop for all manner of hand crafted items,
including Jewellery, Greetings Cards and Gifts