To check for more than one channel-per-record in the table: select channel,count(*) as cnt from ChannelStatus group by channel having cnt>1
should return zero records if you have no dups. On 9/29/05, Hal Vaughan <[EMAIL PROTECTED]> wrote: > I have a query like this: > > SELECT DISTINCT Channel, ChannelType, Source FROM ChannelStatus; > > Each channel is supposedly listed in this table only 1 time, but just in case, > what I really want to do is make sure that no channels are duplicated. Is > there some way to make the keyword "DISTINCT" apply to Channel only? Sort of > a shortcut to (example in pseudocode, although it'd be in Perl): > > SELECT DISTINCT Channel FROM ChannelStatus; > FOR EACH Channel > SELECT Channel, ChannelType FROM Source WHERE Channel = 'channel' > ENDLOOP > > Thanks! > > Hal > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- -Hank -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
