Hibernate Community • View topic - SQL 'like' stm with underscore and escape '\'

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SQL 'like' stm with underscore and escape '\'

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

julias

Post subject: SQL 'like' stm with underscore and escape '\'

Posted: Mon Jun 04, 2007 3:23 am

Newbie

Joined: Thu May 31, 2007 1:02 am
Posts: 1
Location: Israel

Hi
I use this query on oracle:

select * from orgunit WHERE name LIKE '234\_\_\_' escape '\'

I use backslash before every underscore in order to get exactly the name with underscore, I don't want to get every name that starts with"234", but I get more lines than I should:

234523_dddcopy_copy_copy
234___t_c_
234__t_c_

It seems that escape '\' is ignored. How can I use it to get right results?

Appreciate any help or suggestion

julia

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum