MYSQL QUERY HELP!!
how to do this query...Anyone can help me?
I have a table called "tbljobpost" and field "job_id Int , job_title Varchar(50), skill_cat_id varchar(50)"
and table called "tblappskills" and field "app_control Int, skill_cat_id Varchar(50)"
tbljobpost
+----------------------------------------------------------+
|-- job_id -|-- job_title --|------ skill_cat_id -------|
+----------------------------------------------------------+
|---- 1 ----|-- Programmer -|------ 1,2,3,4,5,6,7 --|
+----------------------------------------------------------+
tblappskills
+--------------------------------------------------+
|--- app_control -|------ skill_cat_id -------|
+--------------------------------------------------+
|------ 1 ---------|------- 1,2,4,5,6 ------------|
|------ 2 ---------|------- 1,2,3,7,4 ------------|
|------ 3 ---------|------- 1,2,3,4,5,6,7 -------|
|------ 4 ---------|------- 7,1,4,5,6,2,3 -------|
+--------------------------------------------------+
how i can query or filter the tblappskills that is the same skill_cat_id separated with comma from tbljobpost.
and the result will come like this..
+--------------------------------------------------+
|--- app_control -|------ skill_cat_id -------|
+--------------------------------------------------+
|------ 3 ---------|------- 1,2,3,4,5,6,7 -------|
|------ 4 ---------|------- 7,1,4,5,6,2,3 -------|
+--------------------------------------------------+
tnx in advance for helping...