How to Search substring in Multiple columns using Hibernate

Question

following is my code to call the database to find the substring "ello".

String queryString = "from ContentItem where singerName = '%"+searchString+"%' OR  songName = '%"+searchString+"%'";
System.out.println(queryString);
Query query = session.createQuery(queryString);
return query.list();

the string output is

from ContentItem where singerName = '%ello%' OR songName = '%ello%'

it says Unexpected Token for %. How to make this possible to search substring inside those columns?

I'm working Hibernate inside Tapestry.

pstanton · Accepted Answer · 2012-10-26 08:09:34Z

1

the equals (=) operator does not work with wildcards. You need to use like (or ilike).

eg

SELECT * FROM table WHERE column like '%abc%';

see this document for more info.

answered Oct 26, 2012 at 8:09

pstanton

36.9k28 gold badges131 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Search substring in Multiple columns using Hibernate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related