there are 3 fields in my table ( type , id , tags ) . (tag(s) are separated by commas only in tags colunm)
when user enter any string , it should break into parts (by space) and the each part of that string should try to mtach through eachTAG in all rows of tags column , when it matches in any of the tag present in rows of TAGS column. those rows should be added in datable
how can i do it ?
TYPE ||ID || Tags
typ1 ||1 || tag3,a,b,c
type3||2 || tag4,r,e
asf ||3 ||tag5,y,u,q,e,w
aaa ||4 || e,f,g,h
when user enter "tag3 r u"
the table shoud send these data of ID 1,2,3 and their types only by finding from tags column
Please provide query in stored procedure. im begineer