Replacing Part of a string within a group Concat

0 votes

0 answers

482 views

                          I have part of a string that I would like to remove when selecting.  The Problem is that there are a few pieces within the string that changes.  This is what I have so far.

     Select
      GROUP_CONCAT(DISTINCT Substr(Concat(Round(ms_cart.cart_qty), 'x', ms_cart.cart_sku), 1, 12), Concat(' | ', ms_cart_options.co_opt_name), Replace(ms_cart_options.co_opt_name, 'This is a buddy package.  Who will the buddy photo be taken with: THIS PART CHANGES  What team?: THIS PART CHANGES', ''))
    as Items FROM ms_cart
      INNER JOIN ms_orders ON ms_orders.order_id = ms_cart.cart_order
     INNER JOIN ms_cart_options ON ms_cart_options.co_cart_id=ms_cart.cart_id

Asked by Joey Freeman (1 rep)

Nov 21, 2022, 05:58 AM
Last activity: Nov 21, 2022, 01:50 PM

Replacing Part of a string within a group Concat

This is a buddy package. Who will the buddy photo be taken with

What team?: THIS PART CHANGES', '')) as Items FROM ms_cart INNER JOIN ms_orders ON ms_orders.order_id = ms_cart.cart_order INNER JOIN ms_cart_options ON ms_cart_options.co_cart_id=ms_cart.cart_id

Related Questions