Remove a character from beginning of a field value in MySQL

[Vincentas]

Hi guys,

I have about 2000 records in a MySql table. a specific field in some of them starts with colon character ( that is not needed. I have to remove this character from the beginning of it.

How can I do that ? Should I use regular expression ?

 

[PhpOG]

Download the database and open in a text editor that have search and replace and search and replace something like ','; with ','

easiest way.

 

[Vincentas]

Thanks