Hello,
I just checked the list for answer to this question and looks like there
hasn't been one. I have a similar problem, I want to delete a record
from a table where the value of the field is equal to the value of a
field in another table.
delete from table1 where table1.column = table2.column
Hi Everyone,
I'm writing a script using perl for a search function. I have a large
text column that I want to scan for certain words. I do something like
the following:
select * from table_name where column_1 LIKE "%word1%" AND column_1 LIKE
"%word2%";
In this situation, words like 'tree' will
Hi Everyone,
Does this make sense:
select * from table_name where column_1 LIKE "%word1% OR %word2%";
yeilds 1 record but...
select * from table_name where column_1 LIKE "%word2% OR %word1%";
yields 0 records.
I'm scanning a VARCHAR column trying to return records that contain or
word1 and
The redhat 7 mysql version doesn't work correctly...i.e. the mysql.h is
missing. The solution is to re-install with the a tarball from the
mysql site.. :(
eric
-Original Message-
From: Gordon Stewart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:29 AM
To: [EMAIL PROTECT
I had problems with the DBD as well...the problem was the mysql version
I was using from my redhat cd had some bugs. I would grab the latest
version and re-install mysql, at least this way you know it's not a
version problem
e
-Original Message-
From: Chris Becker [mailto:[EMAIL P
Hello,
I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
Mysql version that came on the redhat cd's. Perl and the Perl DBI are
installed and working correctly. MySql seems to be working correctly as
well(i.e. no problems with permissions, created db's, tables, etc).
Howe
