Solved MySQL Query
#1
Question 
Hoping someone can help me with a query...

My XBMC setup uses MySQL for its database backend. I'm looking to write a query that will give me a list of television shows in which all episodes have been marked as watched.

Anyone know MySQL enough to help? Thanks in advance!
Reply
#2
I was able to solve it with the following query:

Code:
SELECT DISTINCT myvideos75.episodeview.strTitle
  FROM myvideos75.episodeview
WHERE myvideos75.episodeview.strTitle NOT IN
      (SELECT myvideos75.episodeview.strTitle
         FROM myvideos75.episodeview
        WHERE myvideos75.episodeview.playCount IS NULL
      )
ORDER BY strTitle ASC
;
[/code]
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



Logout Mark Read Team Forum Stats Members Help
MySQL Query00
This forum uses Lukasz Tkacz MyBB addons.