[Tcl-tdbc] SQL LIKE '%test%' problem

[Anton <wa...@to...>]

Hi.

Just trying to write on tdbc::mysql instead of mysqltcl package. Can not do query like this:

  SELECT * FROM radcheck WHERE username LIKE '%test%';

code:

set ffff "test";
set stmt [ mh prepare {SELECT * FROM radcheck WHERE username LIKE '%:ffff%'} ];
puts [$stmt allrows];

it returns nothing but when I change it to:

set ffff "%test%";
set stmt [ mh prepare {SELECT * FROM radcheck WHERE username LIKE :ffff} ];
puts [$stmt allrows];

it works like expected.

What is the right way to insert variable in " LIKE '%$var%' " style in tdbc::mysql prepare ?