Re: [fw-db] Zend_DB and RLIKE

On Dec 31, 2010, at 5:11 AM, Robert Stoll wrote:

> 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 '^/[^/]+/?$'

No, there is no such method in current versions of Zend_Db.

In fact, there are no subclasses for Zend_Db_Select that would
generate different SQL for each respective brand of RDBMS. There has
been some talk about this from time to time but so far, no one has
developed the code for it.

Regards,
Bill Karwin