mysql Question

rick809 · **Joined:** Mon May 29, 2006 10:38 am **Posts:** 50

Not sure if this is the best place to ask this. I have some prefix that starts with a "1".

I need to know how to write an sql statement to remove the "1" from every prefix that starts with "1"

Example, New york dial prefix "1212", I need to update it to just be "212"

asiby · **Posted:** Sat Jun 02, 2007 1:44 am

Where will your prefix be? In which table? In what field?

Let's assume that the table is cc_ratecard and that the prefix field is dialprefix.

The query will be:

Code:

UPDATE cc_ratecard
SET dialprefix = MID(dialprefix, 2)
WHERE LEFT(dialprefix, 1) = 1

rick809 · **Joined:** Mon May 29, 2006 10:38 am **Posts:** 50

Asibi:

Your assumptions were correct. Thanks for the help.

provided by Star2Billing S.L.

mysql Question

Who is online