SEO

#1 (**permalink**) 02-28-2008, 10:04 AM

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

#2 (**permalink**) 02-28-2008, 10:04 AM

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

#3 (**permalink**) 02-28-2008, 10:07 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Remove left hand characters from a field.