Does % in like clause of SQL greedy in nature like .*?

I have sql like

SELECT * FROM mytable where username like '%ash%';

I know when we use normal regex .* us greedy in nature & it back track if something is after .* try to match next things. Is is same with SQL internals?