banner
RustyNail

RustyNail

coder. 【blog】https://rustynail.me 【nostr】wss://ts.relays.world/ wss://relays.world/nostr
HomeArchives

sql comma separator

23
AI Translation
This post is translated from Japanese into English through AI.View Original
AI-generated summary
The given SQL query selects distinct values from column "m" and column "f" from tables "mm" and "mysql.help_topic" respectively. It joins the two tables based on the condition where the help_topic_id is 1, 2, or 3.
 select distinct substring_index(substring_index(a.m, ','
                                             , b.help_topic_id + 1), ',', -1) m,
                         a.f
         from mm a
                  join
              mysql.help_topic b
              on b.help_topic_id < (length(a.m) - length(replace(a.m, ',', '')) + 1)
         where type = 2
         
         // m -> 1,2,3
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.