Help for this page

Select Code to Download


  1. or download this
    my sql = qq{SELECT SongTitle, SongPath FROM Songs WHERE  (Songs.Artist
    + LIKE '%'||?||'%' OR Songs.Artist LIKE '%'||?||'%' OR Songs.Artist LI
    +KE '%'||?||'%' OR Songs.Artist LIKE '%'||?||'%' OR Songs.Artist LIKE 
    +'%'||?||'%' OR Songs.Artist LIKE '%'||?||'%' OR Songs.Artist LIKE '%'
    +||?||'%') )};
    
    ...
    my $sto = $dbo->prepare("$sql") 
    
    my $results = $sto->execute( @inc_artists ) or die("Failed to Execute 
    +SQL");