Project scenario:
ruoyi cloud converts mybatis into mybatis plus, executes the querywrapper method, and always reminds of the error. Cause: java.sql.sqlsyntax errorexception: unknown column ‘search_ Value ‘in’ field list ‘
but the corresponding entity class did not find this field. After some efforts, the answer was found in an article, and finally the problem was solved!

Problem Description:

problem screenshot: 

Cause analysis:

because the database does not have this field, ruoyi cloud integrates baseentity, which contains this error field</ font>

Solution:

add annotation @tablefield (exist = false) to the corresponding entity class