title: delete rows using sql 'like' command using data from another table
body: <p>I am trying to delete rows from a table ("lovalarm") where a field ("pointid") is like any one of a number of strings.</p>
  
  <p>Currently I am entering them all manually however I need to be able to have a list of over 100,000 options.</p>
  
  <p>My thoughts are to have a table ("lovdata") containing all possible strings and running a query to delete rows where the field is 'like' any of the strings in the other table.</p>
  
  <p>Can anyone point me in the right direction as to if/how I can use like in this way?</p>
  
  <p>Many thanks,
  Cap</p>