Multiple query on same table

[Staggan]

Hello

 

We have a database table that confirms the installations started and completed for our game... and I am looking to confirm how many installs start but never complete...

 

So, this is my current query...

SELECT description, ip from error_log where description like '%install%' order by ip;

 

 

description can be either install started or install completed and we use the IP to identify a specific user... 

 

 

How do I query that shows the IP's which have a started but no completed in the description ?

 

Any help would be appreciated

 

Thanks

Edited August 28, 2014 by Staggan

[Barand]

Do you log a second record for the IP when installation completed or do you update the original record?

[Staggan]

We log a second record... 

[Barand]

in that case

SELECT inst.ip
FROM 
    (
    SELECT ip 
        FROM error_log WHERE description = 'install' 
    ) inst
    LEFT JOIN
        (
        SELECT ip 
        FROM error_log WHERE description = 'install completed'
        ) comp
    USING (ip)
WHERE comp.ip IS NULL
ORDER BY ip

edit : Should be "SELECT inst.ip ...

Edited August 28, 2014 by Barand

[Staggan]

Thank you for the quick replies and help.... works fine.