title: Sqlite - How to remove substring in a field using wildcards
body: <p>I would like to remove all occurrences of a certain string pattern across all fields in a table. </p>
  
  <p>For example, find all occurrences of the pattern <code>"&lt;XY&gt;*&lt;Xy&gt;"</code> where <code>*</code> represents any possible configuration of characters. I want to remove just those substrings and leave the remainder of the string intact. </p>
  
  <p>This is an example of what I would like to use as my SQL command, but of course this doesn't work:</p>
  
  <p><code>UPDATE Table SET Field = replace(Field, '&lt;XY&gt;*&lt;Xy&gt;', '');</code></p>
  
  <p>What is the solution? </p>