Re: How to use Like Clause in Perl? Works fine in MySQL control center!

[Frank Bax]

At 07:03 PM 7/22/05, Siegfried Heintze wrote:

I'm having trouble getting the like clause to work. It seems to work fine in
the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug.
use DBH;
my $sth = DBH->prepare("SELECT 'David!' LIKE '%D%v%'");
$sth->execute();
my $row;
print join(@$row,",")."\n" while ($row = $sth->fetch);

This does not print a "1" in perl. It just prints a ",".


        join(",",@$row) 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]