2
I have a field text
that is being inserted in the same phones in that format:
11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333
And I need to list these fields as a simple select
in line and spine. the result I need is this:
11 2222-3333
12 9 1111-2222
18 1111-2222
11 2222-3333
ok in php works but need it to be specifically in a mysql select
– Neoelectronics
@user7520, mysql does not have native function to break string into type lines
explode
PHP, what you can do is create aprocedure
to count the number of separators and take the values withSUBSTRING_INDEX
, see a simple example http://sqlfiddle.com/#! 2/a1e1e/11– abfurlan
@user7520 maybe this will also help you http://gustavostraube.wordpress.com/2012/12/split-string-no-mysql/
– abfurlan