1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How can I extract address, city, state and Postal code from a text separated by * using REGEXP_SUBST

Discussion in 'MySQL' started by asifakhtar, Nov 17, 2022.

0
  1. #1
    REGEXP_SUBSTR('4550 Montgomery Avenue*Toronto*Ontario*M4A 2S3*', '(.*? ){2}(.*?),')

    I get a list of dynamic text which contains address, city, state and Postal code separated by *. Need to exact address, city, state and Postal code using REGEXP_SUBSTR.
     
    asifakhtar, Nov 17, 2022 IP