Remove left hand characters from a field.

07-02-2007, 10:58 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

07-02-2007, 10:58 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

07-02-2007, 10:59 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
special characters	Mandragon03@gmail.com	Database	1	07-01-2007 11:00 PM
change some characters into one string	[XaToA]	PHP	1	07-01-2007 3:41 PM
Speed of characters in server	Fletcher	Console Subjects	1	06-26-2007 11:01 AM
accented characters question	David Floyd	Database	4	06-26-2007 12:08 AM
using non-latin characters	jim	Database	0	06-10-2007 12:27 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)