How to truncate a row based on column data?
<p>For example if characterid = null I want the entire row removed: example of what I want removed:</p>
<p><a href="https://i.stack.imgur.com/d2Bp6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d2Bp6.png" alt="http://puu.sh/mhveP/b2df36f6cc.png" /></a></p>
<p>but if characterid has a value then I want to keep the entire row: example of row I want to keep:</p>
<p><a href="https://i.stack.imgur.com/DYjA9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DYjA9.png" alt="enter image description here" /></a></p>
<p>Obviously I can remove the rows myself manually but it would take way to long to do them all.</p>