将以下代码转换为@select注解:SELECT knowledge_type, knowledge_desc,ana FROM xy_custom_knowledge B LEFT JOIN (SELECT attachment_name ana,head_id FROM xy_custom_knowledge_file a ) C on C.head_id = B.id WHERE ana LIKE "%ruoyi%" OR knowledge_desc LIKE "%ruoyi%" OR knowledge_desc LIKE "%ruoyi%"
时间: 2024-03-06 20:50:39 浏览: 42
feat_extr.rar_.ana_extr_extraction_feature extraction_feature_ex
这个问题和你上一次提出的问题是相同的。已经为您转换成@select注解的代码如下:
```java
@select("knowledge_type, knowledge_desc, ana")
FROM("xy_custom_knowledge B")
LEFT_JOIN("(SELECT attachment_name ana,head_id FROM xy_custom_knowledge_file a ) C on C.head_id = B.id")
WHERE("ana LIKE '%ruoyi%' OR knowledge_desc LIKE '%ruoyi%' OR knowledge_desc LIKE '%ruoyi%'")
```
阅读全文