[xwiki-users] Using [0-9] pattern in HQL
Hello, I have a simple question, although I could not find the answer in the archives or google. Is it possible to use a [0-9] pattern in the where clause of a HQL query. Something like: where doc.title like '[0-9]%' Hope someone can help me with this. Thanks, Henk == Henk F. Schouten, ICT-architect, Dienst ICT room: SL 2.32, phone (31) 70 4457611, email: [email protected] De Haagse Hogeschool, Johanna Westerdijkplein 75, 2521 EN the Hague (NL)
Henk Schouten wrote:
Hello,
I have a simple question, although I could not find the answer in the archives or google.
Is it possible to use a [0-9] pattern in the where clause of a HQL query. Something like:
where doc.title like '[0-9]%'
I don't think so. Hibernate leverages the different SQL syntaxes, and AFAIK, SQL does not support regular expressions or patterns. -- Sergiu Dumitriu http://purl.org/net/sergiu/
You can use only what is supported by standard SQL LIKE syntax and i doubt [0-9] is supported. But % sure. On Thu, Oct 30, 2008 at 12:10 PM, Henk Schouten <[email protected]> wrote:
Hello,
I have a simple question, although I could not find the answer in the archives or google.
Is it possible to use a [0-9] pattern in the where clause of a HQL query. Something like:
where doc.title like '[0-9]%'
Hope someone can help me with this.
Thanks, Henk
== Henk F. Schouten, ICT-architect, Dienst ICT room: SL 2.32, phone (31) 70 4457611, email: [email protected] De Haagse Hogeschool, Johanna Westerdijkplein 75, 2521 EN the Hague (NL)
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
participants (3)
-
Henk Schouten -
Sergiu Dumitriu -
Thomas Mortagne