title: How to replace numeric character with "%" in MySQL?
body: <p>How to replace numeric character with "%" in MySQL ?</p>
  
  <p>i.e :  abcd 1234 zz  => abcd %%%% zz</p>
  
  <p><strong>What I have :</strong> </p>
  
  <pre><code>Declare cursorVideoTitles cursor  for select temp_playList.VideoTitle 
        from temp_playList  where temp_playList.VideoTitle regexp '^[A-Za-z0-9]+$';
  </code></pre>
  
  <p>cursorVideoTitles  contain all alphanumeric video titles. now after this I need to replace numeric character with "%"</p>
  
  <p><strong>Reason for this :</strong> 
  I need to search it in other table which have same alphabets. 
  so 1st I take all those values in cursor variable and iterate it with like query,so i will get  matching records.</p>