Question

mybatis中如何引用一个查询的结果作为另一个查询的条件

Answer 1

SELECT * FROM user_info WHERE "name" LIKE (SELECT "name" FROM store WHERE "id"=8) 这是我刚查出来的，name和后面国号里的结果只能是字符才行

追问

类似于这种查询，该怎么处理啊
"select news_title from news where FIND_IN_SET(SELECT keyword from news WHERE news_id=6,keyword)";