<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">"IS" is only valid as a comparison operator for the "NULL" special value.<br>
Otherwise, use a simple good old "=" sign:<br>
<br>
select * from recorded where chanid = 44;<br>
<font color="#888888"><br>
--<br>
Mike Holden<br>
<br></font><br></blockquote></div><br>Thanks Mike, well I got all of them to show up in the shell now. however I'm at the mysql> prompt and for fear due to noobness with mysql I will go ahead and ask exactly how I alter the chanid for all these. I just did select * from recorded where chanid = 44;.<br>
<br>Thanks<br>Bob<br>