Table Name "MY_TABLE" data as given below
ID,NAME
1,"A"
2,"B"
100,"C"
200,"D"

What I am trying is here.

SELECT A.ID,A.NAME,B.ID,B.NAME FROM MY_TABLE A JOIN MY_TABLE B ON A.ID like B.ID*10 || '%' WHERE B.NAME = "B";

Expecting answer
A.ID, A.NAME,B.ID,B.NAME
200 ,  "D"  ,  2 , "B"

but LIKE with multiplication and '%' not working for SQL LITE. Same can be done with MySQL.