HQL + LIKE + _

[kri shan]

I am using LIKE in HQL. Hence it takes all records that matches LIKE including _(under score). But i want to omit under score(_). How ?

[kri shan]

any update ?

[Ulf Dittmer]

Can you tell us what exactly you're trying to do? If you want to match all strings containing an underscore, that character will need to be in the LIKE phrase. What would be the point of keeping it out of the match pattern?

[kri shan]

Hi Ulf, LIKE should match with only characters, not any special characters(_).

[kri shan]

Hi Ulf Dittmer, Any update ?

[Ulf Dittmer]

How about adding another phrase like "... AND NOT LIKE '%_%'"? Or -for better performance- work with the SQL equivalent of String.indexOf.

Or are there other special characters you want to exclude as well?

By the way, please don't ask for answers from specific people. It makes others -who may have more to contribute- feel excluded and unwelcomed.

[kri shan]

I want to exclude all special characters. How (not using AND NOT LIKE '%_%'")?

[kri shan]

Any update ???