[Zope] Re: [LAzug] ZSQL Like Statement

[Andrew Ho]

On Mon, 22 Oct 2001, Mike Doanh Tran wrote:
...
> Does anyone know how to do a query in ZSQL with the "LIKE" statement?
> This is what i want to do:
>
> select * from database where start_date LIKE '2001/10/%' ;
>
> what is the ZSQL statement equivalent of mysql "LIKE" and the wild card
> symbol?

Mike,
  ZSQL statements are passed to the database (DBMS). So, whatever
"statement syntax" is supported by your database will be the right syntax.

You need to read the documentation for your particular DBMS to find out
how to do "SELECT ... WHERE ... LIKE". Since this is not part of Zope, I
am not surprised that you cannot find reference to this at Zope.Org.

Hope that helps,

Andrew
---
Andrew P. Ho, M.D.
OIO: Open Infrastructure for Outcomes
www.TxOutcome.Org