like another field concat in MYSQL -

i trying use inner join statement...

inner join r_data r on r.ids_logs concat("%",l.id,"%") 

...but error message.

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 5

why error generated?

there appears invalid character @ end of inner join statement.

try remove character , try again execute statement.