Mysql sql complex query statement

now there are two tables, as shown in the figure
clipboard.png


clipboard.png

the question is: how do I write a sql statement to query the data that contains a field (user_id) in Table 2 (m_top_user_list)? Thank you ~

Mar.29,2021

select t2.* from T1 LEFT JOIN t 2 where find_in_set (t 1.userkeeper dagger t2.m recording topical usernames list)


select * from T2 LEFT JOIN T1 ON T2. M_top_user_list like'% T1. User_id%'

Menu