How do you do this:
SELECT * FROM table1 WHERE table1.field1=0
--
SELECT * FROM table1 WHERE table1.field1=0
Is there a function in mysql that allows you to
evaluate(dunno whether I use the correct term here)
the string and not to treat it like a string?
TIA.
Ho Keat
I think I will describe the problem in detail.
I using Container-Managed Persistence (CMP) beans in
J2EE RI 1.3. I will like to specify the SQL for one
of the finder methods to be:
SELECT * FROM table1 WHERE ( ? )
This is to faciliate me manipulating the WHERE clause
b4 sending it as a