cayenne-user mailing list archives

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

A question about escaping a LIKE qualifier;

	ExpressionFactory.likeExp(...,...)

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.

Regards;

___
Andrew Lindesay
www.lindesay.co.nz


Mime
View raw message