Hi,
Thank you for looking into this.

I'm trying to have a query of this form:
SELECT * FROM table1, table2 WHERE table2.ids LIKE '%table1.id%' AND table2.status = 'something'

basically, I need to insert table1.id value into LIKE query. table1.id have one numeric value and table2.ids have varchar value like '1, 3, 344, 222'.

Thanks again,
Eugene

the easiest thing would be to redesign the table so that you do not have a series of ids in a single column

do a search for first normal form