Re: Regexp, replace ??? what do I need to use

[sumit durugkar]

Sandra Rascheli Wrote:
-------------------------------------------------------
> Hello Felix, the query seems to work fine except
> on a few occasions which I am trying to understand
> what it does because it generates the new number
>
> SELECT identification,
> GROUP_CONCAT(SUBSTRING(identification, i, 1) ORDER
> BY i SEPARATOR '')
> FROM clientstemporal
> JOIN ints ON i BETWEEN 1 AND
> LENGTH(identification)
> WHERE
> SUBSTRING(identification, i, 1) IN ('0', '1',
> '2', '3', '4', '5', '6', '7', '8', '9')
> GROUP BY identification;
>
> partial result:
> 72522084 | 7722552222008844
>
> this seems to happen randomly I suppose because it
> only happens to some particular numbers as in this
> example.
> What could be the problem with the query?
> Many thanks for your help.


Hi Sandra and Felix,

This is the same problem that I am facing with. You mentioned that after running this query you are getting incorrect result for some entries in the table(most probably duplicate entries). Did you manage to get rid of that ???

I have to apply this query on such a table which necessarily have the duplicate entries. Any suggestion from your side how should I handle the duplicate entries in the same query so that the result for extracting the data will not currupt for duplicate entries too?

Regards,
Sumit.