Sql syntax to Trim alphanumeric data in mysql phpmyAdmin

Question

Is there any syntax query in mysql phpmyadmin to trim alphanumeric(varchar) data? Here's how I want it to happen:

In my table i have two fields id(int) and promocode(varchar)(25), inside my promocode column I have this sample data BEFKR679GKQTX46AFKP14VY composed of (25) ...and i want it to trim the first 12 alphanumeric only, making it look like these BEFKR679GKQT.. and I don't know how to change the existing 1,000 inputted data in my table.. into all 12 not 25.

Francisco · Accepted Answer · 2017-08-04 04:32:37Z

1

Back up your tables. If you can't do this, don't continue.
Test a command like on a test table and make sure you understand it:
```
UPDATE my_table SET promocode = SUBSTRING(promocode,1,12);
```
When it works you your satisfaction on test tables, and your back up is complete, do it to the real table.

More info on MySQL string functions is here:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html

Running SQL from phpMyAdmin is here:

http://community.mybb.com/thread-4720.html

edited Aug 4, 2017 at 4:32

Francisco

11.6k6 gold badges37 silver badges47 bronze badges

answered Jan 26, 2011 at 2:22

john personna

4423 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql syntax to Trim alphanumeric data in mysql phpmyAdmin

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related