MYSQL 字符串转为列表，作为关联条件查询【有待完善，只是能用】

最新推荐文章于 2024-11-22 18:29:00 发布

原创最新推荐文章于 2024-11-22 18:29:00 发布 · 1.4k 阅读

1 ·

CC 4.0 BY-SA版权

MYSQL 专栏收录该内容

12 篇文章

订阅专栏

本文深入探讨了复杂的SQL查询技巧，通过实例展示了如何使用子查询、连接、子串操作及条件筛选进行高级数据检索。适用于数据库管理员及高级开发人员。

SELECT *
FROM ttmro_product.prod_catalog
WHERE catalog_id IN (
SELECT DISTINCT
   *
FROM
   (
SELECT
   SUBSTRING_INDEX(
   SUBSTRING_INDEX(
   (
SELECT
   setting.text
FROM
   com_temp_setting setting
   LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id
WHERE
   detail.relation_type = '03'
   AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a'
   AND setting.del_flag = '0'
   LIMIT 1
   ),
   ',',
   help_topic_id + 1
   ),
   ',',- 1
   ) AS num
FROM
   mysql.help_topic
WHERE
   help_topic_id < LENGTH(
   (
SELECT
   setting.text
FROM
   com_temp_setting setting
   LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id
WHERE
   detail.relation_type = '03'
   AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a'
   AND setting.del_flag = '0'
   LIMIT 1
   )
   ) - LENGTH(
   REPLACE (
   (
SELECT
   setting.text
FROM
   com_temp_setting setting
   LEFT JOIN modular_detail detail ON detail.relation_id = setting.relation_id
WHERE
   detail.relation_type = '03'
   AND setting.tenant_id = 'c8b8ffeee0b048cb91162659c5983921d086eb5d60744c9b97a1cac36691928a'
   AND setting.del_flag = '0'
   LIMIT 1
   ),
   ',',
   ''
   )
   ) + 1
   ) T2
)