use wildcards with update and replace <p>I have a very large MySQL table with lots of data in it, one of the fields is Invoice No, and is a number starting at 1000.001 (This is a string). I have got this from someone that left the company and they imported the data through excel and some of the numbers have come across as 1000.01 instead of 1000.010.</p> <p>When I run this query in php my admin, it shows there are over 11k rows, so I can see them ok.</p> <pre><code>SELECT `AnalysisID` , `InvoiceNo` FROM `STStbl000010` WHERE `InvoiceNo` LIKE '%.__' ORDER BY `STStbl000010`.`AnalysisID` ASC </code></pre> <p>So simply put I need to add a 0 (Zero) to the end of those entries.</p> <p>I have tried the following, however, it just returns 0 rows effected.</p> <p>Can I use wildcards like this in and Update and Replace Statement?</p> <pre><code>UPDATE `STStbl000010AT` SET `InvoiceNo` = replace(`InvoiceNo`, '%.__', '%.__0') WHERE `InvoiceNo` LIKE '%.__' </code></pre> <p>Thanks</p>