List:General Discussion« Previous MessageNext Message »
From:Reinhart Viane Date:May 11 2005 11:34am
Subject:RE: Remove 1st 3 Chars
View as plain text  
Look at the substring example here
http://dev.mysql.com/doc/mysql/en/string-functions.html

Regards,
Reinhart Viane

-----Oorspronkelijk bericht-----
Van: shaun thornburgh [mailto:shaunthornburgh@stripped] 
Verzonden: woensdag 11 mei 2005 13:30
Aan: mysql@stripped
Onderwerp: Remove 1st 3 Chars

Hi,

is it possible to alter fields in a column by removing the first three 
characters?

i.e. change 100123456789 to 123456789

Thanks for your help



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1




-- 
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 10/05/2005


Thread
Remove 1st 3 Charsshaun thornburgh11 May
  • RE: Remove 1st 3 CharsReinhart Viane11 May
  • Re: Remove 1st 3 CharsJohan Höök11 May
RE: Remove 1st 3 CharsAndrew Braithwaite11 May
  • Re: Remove 1st 3 CharsPhilippe Poelvoorde11 May
  • RE: Remove 1st 3 CharsAndy Eastham11 May
  • Re: Remove 1st 3 CharsRoger Baklund11 May