A
Anonymous
Guest
Hi guys
How can I remove a character on a certain column. For example, I have a table in mysql and it has a column "cert_no" (varchar). This column should only have numbers in it, but for some reason when I imported a csv file, some values on the column has "-" before the number ex. -44567. How can i remove all the "-" before the number using phpmyadmin?
Thank you very much.
How can I remove a character on a certain column. For example, I have a table in mysql and it has a column "cert_no" (varchar). This column should only have numbers in it, but for some reason when I imported a csv file, some values on the column has "-" before the number ex. -44567. How can i remove all the "-" before the number using phpmyadmin?
Thank you very much.