cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Lindesay <>
Subject Using an Escaped LIKE Clause
Date Thu, 28 Jan 2010 01:41:46 GMT

A question about escaping a LIKE qualifier;


JDBC specifies the ability to use '%' and '_' as matchers for characters and a character respectively.
 It is then possible to escape use of those characters as in the following example;

	SELECT a FROM tabA WHERE a LIKE '%=_' {escape '='}

I can't easily see a means by which one can specify the "escape" clause in a SelectQuery --
can anybody shed some light on this for me.


Andrew Lindesay

View raw message