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%'

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e47cef-44c57.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e47cef-44c57.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?