You can do the same thing with like:
where concat(",",myField,",") like "%,$searchString,%"
this will of cause be somewhat slow, how about normalizing your database:
header(id,fields)
type(id,dataset)
header(1,)
type(1,black)
type(1,dark)
...
now you can select * from header,type where (id=
But does that really change anything on the database server side ?
In other words is MySQL doing anything with respect to using prepared
statements ?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 3:01 AM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED];
I think what is needed here is a small perl program that
does a "show databases"
and then
pseudo code Q&D:
#!/bin/perl -w
use MySql;
$command = $ARGV[0];
$dbh=MySql->connect('mysql','localhost');
$sth=$dbh->query('show databases');
while ($db
ut what's the most elegant way to do the join to get it back as one
resultSet ?
I was thinking of maybe using the same logic as for the permission system
inside of MySql with % or something as wildcards but left it empty sting for
now. Which also leads me to another question as I woul
can be done on the application level. I am wondering if I need to OR
should create a query in the application doing the various or conditions or
if there is a more elegant solution.
Note: I left out the NOT NULL and the index definition.
Martin Hubert
Freightgate - New Dimensions in