The _ (underscore) given in the SQL query is not honored.
Example :
SELECT * FROM employee WHERE NAME LIKE '%k_p%';
This matches and brings many rows apart from rows which contain k_p
Could someone please assist on how to achieve this in SQL and also in Hibernate? Thanks.
Have you tried escaping it:
SELECT * FROM employee WHERE NAME LIKE '%k\_p%';
\_ instead of just _.
% somewhere in there, and didn't want to do lots of escaping. I found I can use RLIKE instead of LIKE and just use the Regex syntax .* instead of %, and input the underscores plainly. I might prefer this in SQL from now on since like JSON, I might prefer Regex as another common tool to use for any situation.
.* is implicit. You can substitute rlike 'k_p' for like '%k\_p%', and also k_p$ for %k_p, and ^k_p for k_p%.I know it is quite late but can be solution for other programmers. You can try
SELECT * FROM employee WHERE NAME LIKE '%k[_]p%';
