At a guess I would say you need to call replace on the column to replace the percent char with its escaped equivalent. On Tue, 17 May 2016 at 06:11, <[email protected]> wrote:
> I have the following SQL statement that joins 2 tables X and Y and applies > LIKE clause as below on the "PARENT_PATH" column of the Y table. However, > the problem is that values of the "PARENT_PATH" column of the Y table can > potentially have special characters like % within it. So I tried using > square brackets around the Y.PARENT_PATH column as below: > > > > *SELECT DISTINCT X.ID <http://X.ID>FROM X, YWHERE X.col1 = Y.col2 AND > "/a/b/c" LIKE [Y.PARENT_PATH]%* > > However, I got the following error from H2 database: > > > > > *org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT > DISTINCT X.ID <http://X.ID>FROM X, YWHERE X.col1 = Y.col2 AND "/a/b/c" > LIKE [[*]Y.PARENT_PATH]%* > Any ideas on how to solve this problem? Please note that the column > Y.PARENT_PATH is on the right side of the LIKE clause, and can have special > characters such as % within it. What is the best way to solve this problem > with SQL? > > Thanks a lot for the help in advance! > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
