Like operator does not work as in other databases

This is a bug that makes it impossible to replace some applications written for MS SQL or Oracle, etc.
The Like operator works only when the column is on the left, and in the right side there is an expression to be matched.
for instance
select * from Table where npanxx like '9544%'
it correctly finds row with value '954444'

But,in all databases that I know of, this also finds that match

select * from Table where '9544447408' like concat(npanxx,'%')

It does not work in MariaDB, and it should. I am not sure about MySQL, but in any case, it is a bug and we need to fix it and make it efficient.