Vincentas Established Member Impact 4 Jan 8, 2013 2K views 2 replies #1 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 ? Click to expand...
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 ?
RevJparisCoder Code NinjaUpgraded Member Gold Account ★★★★★★★★★★ Impact 34 Jan 9, 2013 1 point #2 Download the database and open in a text editor that have search and replace and search and replace something like ','; with ',' easiest way. Click to expand...
Download the database and open in a text editor that have search and replace and search and replace something like ','; with ',' easiest way.