title: Masking a query string param value using Postgres regexp_replace
body: <p>I want to mask movie names with <code>XXXXXXXX</code> in a PostgreSQL table column. The content of the column is something like </p>
  
  <pre><code>hollywood_genre_movieTitle0=The watergate&amp;categorey=blabla&amp;hollywood_genre_movieTitle1=Terminator&amp;hollywood_genre_movieTitle2=Spartacus&amp;hollywood_genre_movieTitle3=John Wayne and the Indians&amp;categorey=blabla&amp;hollywood_genre_movieTitle4=Start Trek&amp;hollywood_genre_movieTitle5=ET&amp;categorey=blabla
  </code></pre>
  
  <p>And I would like  to mask the titles (behind the pattern <code>hollywood_genre_movieTitle\d</code>) using the <code>regexp_replace</code> function</p>
  
  <pre><code>regexp_replace('(hollywood_genre_movieTitle\d+=)(.*?)(&amp;?)', '\1XXXXXXXX\3', 'g')
  </code></pre>
  
  <p>This just replaces the first occurrence of a title and  and cuts the string. In short this expression does not do the thing  I want. What I would like is that all movies names are replace with <code>XXXXXXXX</code>.</p>
  
  <p>Can someone help me solve that?</p>