jpa sql查询的问题
@Query(value = "select * from t_sub_forum s where id in (select f.sub_forum_id from t_sub_forum_user f where f.user_id = id ) and s.record_status= 0 and s.theme like '%theme%';",nativeQuery = true)
Page<SubForumEntity> getListByPage(@Param("theme") String theme,@Param("id") long id,
Pageable pageRequest);
报错:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by s.timeStart desc limit 50' at line 1
但是我在navicat查询这个语句的时候 就能执行成功