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

Loony2nz says...
> 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)

SELECT SUBSTR(<column_name>, 5) FROM <table_name>;

GM

On Jun 20, 5:49 pm, Geoff Muldoon <geoff.muld...@trap.gmail.com>
wrote:
> Loony2nz says...
>
> > 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)
>
> SELECT SUBSTR(<column_name>, 5) FROM <table_name>;
>
> GM

MUCHOS GRACIAS MI AMIGO!!

That's just what I wanted!

--Chris