How to use like '%%' in metabase mysql question?

How should I use like %% in metabase mysql question? When I use something like:
where uid like %{{}}% it gives an error. I have tested many ways but it does not seem to work!

Anyone has any solution for it?

Found a solution!

where uid like “%”{{}}"%"

2 Likes