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

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

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