I am a database novice. My senior assigned me a keyword query task. I encountered some problems when writing the database query statement.
select * from COMPLIANCE_CONSULT where CONSULT_TITLE like '%keyword%'or CONSULT_CONTENT like '%keyword%'or REPLY_CONTENT like '%keyword%'or REPLY_ATTACH like '%keyword%'
This is the sql query statement I wrote. Now I need to write it into the code and write it like this
This is the original keyword query, but I need to write four query conditions. If it is written like this, what should it look like, or what should the format be like?
Change "and" in jpql to "or"
The pair returned upstairs can be optimized. String string splicing takes up memory. You can use stringBuilder.append for splicing