in reply to Re: Re: SQL pulling information
in thread SQL pulling information
Does this help you?use strict; use DBI; my $mynumber=44; # Boilerplate connect code skipped. my $sth=$dbh->prepare("select column from table where column LIKE '%$m +ynumber%'"); $sth->execute; while (my $ref=$sth->fetchrow_arrayref) { my @numbers=split /|/, $ref->[0]; # do something with @numbers, optionally if /44/ } print "This code is untested. Beware of dragons.\n";
CU
Robartes-
|
|---|