PHP MySQL inner join issues -

basically have 2 tables: nodes , nature. nodes have auto-incrementing id, , nature has 'node' column focusing on here. node column contains delimited string of ids nodes table (the nodes nature entry in.)

an example of node column in nature table might this:

.1.10.597.598.599.600. 

there periods in front , behind each id can search images in node (where node '%.".$_get['id'].".%') example.

that being said trying select entries node table have entries in nature table. here's i've got far returns empty set.

select * nodes inner join nature b on a.id '%.b.node.%' 

any appreciated.

use concat function

on a.id concat('%.',b.node,'.%')