求教mybatis怎么使用binary

新手上路,请多包涵

<select id="getLifecycleTemplateByName" resultType="com.mi.sc.plm.lifecycle.vo.LifecycleTemplateQueryVo">

    select
    <include refid="Base_Column_List"/>
    from plm_lifecycle_template
    <where>
        BINARY template_name =  #{templateName} and deleted = 0 and latest = 1
    </where>
</select>

执行后异常

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "BINARY" "BINARY"

at line 6, column 16.

Was expecting one of:

"!"
"("
"NOT"
阅读 3.9k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进