package com.tievd.jyz.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tievd.jyz.entity.Label;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Label
 * @author      cube
 * @since       2023-02-27
 * @version     V2.0.0
 */
public interface LabelMapper extends BaseMapper<Label> {

    @Select("select SUBSTRING_INDEX( SUBSTRING_INDEX( a.label_name, ',', b.help_topic_id + 1 ), ',',- 1 ) from t_label a JOIN mysql.help_topic b ON b.help_topic_id < ( LENGTH( a.label_name ) - LENGTH( REPLACE ( a.label_name, ',', '' ) ) + 1 );")
    List<String> listLabel();
}