 Remove left hand characters from a field. | |
How do you remove, say the first 4 characters from a field?
I have a bunch of department names in a column that is prefaced with
accounting codes.
Ex. 715-Human Resources, 813-Operations
What's the MySQL query to remove the first 4 characters? (yes, they're
consistent)
Thanks!
chris
|