Found others looking for the same, how to use wildcard in a JOIN ON using a string reference:
This is how I soleved it with wildcard:
****************************************************************
SELECT acl.* , node.type FROM acl
LEFT JOIN node ON ( acl.name LIKE concat( '%', node.nid ) )
WHERE 1
****************************************************************
This is how I soleved it with fixed value:
****************************************************************
SELECT acl.* , node.type FROM acl
LEFT JOIN node ON ( acl.name LIKE concat( 'view_', node.nid ) )
WHERE 1
****************************************************************
Refering to:
http://forums.mysql.com/read.php?108,396442,396442