my $search = "foobar";
printf "WHERE blah LIKE '%$search%' LIMIT %d,%d\n", 1, 2;

# ... LIKE '%foobar' ...
#           ^^

# WHERE blah LIKE '1.000000oobar%' LIMIT 2,0

##</code><code>##

my $search = "f %d";
printf "WHERE blah LIKE '%$search%' LIMIT %d,%d\n", 1, 2;

# WHERE blah LIKE '1.000000 2%' LIMIT 0,0

##</code><code>##

my $search = "' OR '1' LIKE '1";
printf "WHERE blah LIKE '%$search%' LIMIT %d,%d\n", 1, 2;

# WHERE blah LIKE '%' OR '1' LIKE '1%' LIMIT 1,2