PHP / MySQL Multiple substrings?

Question

I have a field in my table that contains numbers for instance: 7121968 - what I would like to do is add a . before the last four and before the last 6 digits so that it looks like: 7.12.1968. I can use substring to just show the last 4 digits etc - is what i am trying to do possible using substring and if so could someeone point me in the right direction? thanks.

Did you store a date there or are the numbers pure coincidence? — halfdan
– halfdan, Commented Nov 24, 2011 at 13:10
that was pure coincidence - should add i currently have substr(field, -4) — John
– John, Commented Nov 24, 2011 at 13:11

Vilx- · Accepted Answer · 2011-11-24 13:10:38Z

1

$x = '7121968';
$x2 = substr($x,0,-6) . '.' . substr($x,-6,2) . '.' . substr($x,-4);

answered Nov 24, 2011 at 13:10

Vilx-

107k93 gold badges293 silver badges432 bronze badges

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

Comments

zrvan · Accepted Answer · 2011-11-24 13:13:47Z

0

Do like this:

SELECT CONCAT(SUBSTRING(<column>, 1, 1), '.', SUBSTRING(<column>, 2, 2), '.', SUBSTRING(<column>, 4)) FROM <table>

answered Nov 24, 2011 at 13:13

zrvan

7,8031 gold badge25 silver badges24 bronze badges

Collectives™ on Stack Overflow

PHP / MySQL Multiple substrings?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related