remove first character from mysql field

SQL starts counting from 1 and not 0. Try this:

UPDATE `llx_societe` 
SET `code_client`= SUBSTR(code_client,2) 
WHERE `code_client` BETWEEN '00100' AND '00999';

Try this:

  UPDATE llx_societe
    SET code_client= SUBSTR(code_client, 2) 
    WHERE code_client between '00100' AND '00999'

MySQL SUBSTR() function

You can use the following SQL:

UPDATE TABLENAME SET data = SUBSTR(FIELD, 2);

for example if there is table(userinfo) and field is username

UPDATE users SET username = SUBSTR(username, 2);

Related