Evaluating a String

2002-05-21 Thread Ang Ho Keat
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

RE: Evaluating a String

2002-05-21 Thread Ang 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