join table profile to tags

Hello,

I have a table for a multi select of tags.
col1->user_id
col2->tag_id
for other workflow processes
I trying to figure out how to get this as a field in a profile tab that doesn't use comprofiler text col with separater to store but this join table.
I thought i could use the query field type but that only helps with the form select but not store to my join table.
I am not familiar with writing cb code.
I am ok with joomla code
and using fof for my custom views.

I need someone to start me off in the right direction here.
or Is it possible to effective search for id#s in a multiple value column with |*| ?

example
It looks like I might only need a pointer on writing the advanced filter on a user list so it is similar to the advanced search for user management where multiselectfield include any of (SELECT id FROM #__customtbl)

Let me know if I need more clarification.

I can only get FIND_IN_SET to work with comma separation not |*|.

List Management -- advanced FILTER

I want a list of users where any (SELECT id FROM #__tags WHERE parent_id = ##) tag exists in the users multiselect column.

FIND_IN_SET only works with comma separated values as described in MYSQL documentation below.

dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_find-in-set

You can convert it to be comma separated though using the below example.

FIND_IN_SET( 'SEARCH_VALUE', REPLACE( '|*|', ',', '[FIELD_NAME]' ) )