MySQL Left join with Like condition like this -

select user_ip  affi left join cc on affi.user_ip on  "%cc.auth_ip%"  

now ip field in cc table looks : 11.11.11.11:2312 , on affi table looks 11.11.11.11 this.

any ideas? :) in advance

try this

select     user_ip     affi left join     cc on     affi.user_ip concat(cc.auth_ip,'%') 

you try use substr