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
Hi,
Quote from mysql online documentations:
As of Version 4.0.1, MySQL can also perform boolean
full-text
searches using the IN BOOLEAN MODE modifierA
boolean full-text
search can also work even without a FULLTEXT index,
although it would
be slow.
I know that InnoDB does not support
Encounter the following error in MyCC:
[root@localhost:3306]ERROR 1005: Can't create table
'.\abc\def.frm' (errno 121)
I'm using MySQL 3.23.49 and Win98se. The statement I
used work on the default MYISAM table and DBD table
and I did changed the TYPE=InnoDB in the CREATE
statement.
The