title: PHP/SQL Update on String
body: <p>I have an sql field issue_code data type string with the following sample data format &quot;2020-12-0012&quot; with hundreds of records i want to update all from &quot;2020&quot; to &quot;2021&quot; without modifying the rest of the record. how can i query this?</p>