<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">On Jan 13, 2015, at 1:20 PM, Rob <<a href="mailto:bertaboy@gmail.com" class="">bertaboy@gmail.com</a>> wrote:<div class=""><br class=""><div><blockquote type="cite" class=""><div dir="ltr" class=""><div class="gmail_extra"><div class="gmail_quote"><div class="">I'd rather that the scripts run it off VIDEOMETADATA.CONTENTTYPE which identifies the file as:</div><div class=""><span style="color:rgb(37,37,37);font-family:sans-serif;font-size:14px;line-height:22.3999996185303px;background-color:rgb(231,237,245)" class="">set('MOVIE','TELEVISION','ADULT','MUSICVIDEO','HOMEVIDEO')</span><br class=""></div></div></div><div class="gmail_extra"><br class=""></div><div class="gmail_extra">If anyone knows how to perform a lookup for that column, then I can draft up a patch for <a href="https://code.mythtv.org/trac/ticket/12344" class="">https://code.mythtv.org/trac/ticket/12344</a></div></div></blockquote></div><br class=""><div class="">There’s good info at:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span><a href="http://dev.mysql.com/doc/refman/5.0/en/set.html" class="">http://dev.mysql.com/doc/refman/5.0/en/set.html</a></div><div class=""><br class=""></div><div class="">essentially you do updates like:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>update videometadata</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>set contenttype = contenttype & (‘HOMEVIDEO’)</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>where …</div><div class=""><br class=""></div><div class="">and do queries like:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>select title from videometadata</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>where find_in_set(‘HOMEVIDEO’, conttentype) > 0</div><div class=""><br class=""></div><div class="">I’m not sure how you might use a set column directly in Qt but you could convert the set to booleans like:</div><div class=""><br class=""></div><div class=""><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>select title,</div><div class=""> <span class="Apple-tab-span" style="white-space:pre"> </span>find_in_set(‘HOMEVIDEO’, conttentype) > 0 isHomeVideo,</div><div class=""> <span class="Apple-tab-span" style="white-space: pre;"> </span>find_in_set(‘MOVIE’, conttentype) > 0 isMovie</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>from videometadata</div><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span>where find_in_set(‘HOMEVIDEO’, conttentype) > 0</div></div><div class=""><br class=""></div><div class="">- George</div><div class=""><br class=""></div></div></body></html>