remove first character from mysql field
<p>I need advices in order to make a process on my list of values. I have a table <code>llx_societe</code> and some fields where one of them is <code>code_client</code>. This field looks like :</p>

<pre><code>0099
00100
00101
00102
...
00998
00999
001000
</code></pre>

<p>I want to remove the first zero for all values between <code>00100</code> and <code>00999</code> in order to get <code>0100</code> until <code>0999</code>.</p>

<p>I wrote this command :</p>

<pre><code>UPDATE `llx_societe` 
SET `code_client`= SUBSTR(code_client,1) 
WHERE `code_client` BETWEEN '00100' AND '00999';
</code></pre>

<p>But nothing, none lines are proceed.</p>

<p>Have you an explanation ?</p>