@Query(value="select * from post where MATCH(author,content,title,excerpt) AGAINST(':filters')", nativeQuery = true)

Page searchByFilters(@Param("filters")List filters, Pageable pageable);

I am trying to filter my posts using this query, I'm also adding search keyword to the list in my controller

CodePudding user response：

Use a simple query instead, and the problem will be solved.

CodePudding user response：

Adarsh's answer is best, once try it please.