No LIKE condition for mysql?

I realy like using LIKE as a condition and this allow me to use % as a default value if the parameter is empty but it’s missing from condition list in db query…

I can do it in with a custom query and works fine. (i love the test query feature there anyway)

eg:
SELECT * FROM Tasks WHERE Tasks.t_status LIKE :P1 AND Tasks.fk_member_id = :P2

:P1 = {{$_GET.t_status.default("%")}}

Just curious why it’s missing for db query.

thanks

/J