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)