On Tue, 2005-06-28 at 11:20 -0600, C. Ed Felt wrote:
> So, in short, (since a paragraph will get confusing):
>
> 1. SELECT all records in the CDR table after a requested date (usually
> 24 hours).
> 2. Store these records in a huge array.
> 3. Find all repeats on the 'sessid' field and store this in an array.
> 4. Delete all repeats (save one copy of each repeat CDR).
>
> Is there a MySQL query, (version 3), to select all rows that have one or
> more matching rows on a specific field ('sessid')? This would
> essentially combine steps 1, 2 and 3 in one MySQL query.I don't believe this is doable in a single query until MySQL 5. You /might/ be able to do it in 4.1, but I'm not sure. -- Matthew Walker The Brain Garden, Inc [EMAIL PROTECTED] Work: (801) 655-1075 Home: (801) 491-2079 Page: (801) 283-9887 (Emergencies Only) Random Quote: The Official MBA Handbook on business cards: Avoid overly pretentious job titles such as "Lord of the Realm, Defender of the Faith, Emperor of India" or "Director of Corporate Planning."
signature.asc
Description: This is a digitally signed message part
.===================================. | This has been a P.L.U.G. mailing. | | Don't Fear the Penguin. | | IRC: #utah at irc.freenode.net | `==================================='
