2010年12月31日星期五

[fw-db] Zend_DB and RLIKE

Hello

I use Zend_Db because I wish, that my PHP-application is compatible with
many database systems.
But I encounter a problem when I want to use RLIKE (MySQL) or REGEXP_LIKE
(oracle) in the WHERE-clause
Is there any method which provide a mapping for RLIKE -> something like:
$query->where("URL ".$query->rlike('^/[^/]+/?$'));
which results for mysql in ...WHERE URL RLIKE '^/[^/]+/?$'
and for oracle in ...WHERE URL REGEXP_LIKE '^/[^/]+/?$'

Thank's
Robert
--
Neu: GMX De-Mail - Einfach wie E-Mail, sicher wie ein Brief!
Jetzt De-Mail-Adresse reservieren: http://portal.gmx.net/de/go/demail

没有评论: