Such as
tag defines list aThe value label
A1: hello,
A3 & amp; A4: hello

Only in both cases, either contains a separate content, either contains two fields at the same time, use & amp; Notation, the value of the mutex not overlap,

Then there is a need to match the table b
Remark
Audi Ada wet Ada a1
Audi Ada wet Ada a2
A4 audi Ada wet Ada a3
.


Need to look at the table b remark fields, to match a value on the surface of the table, if meet contains a keyword, it returns the label tag

Could you tell me how to achieve this requirement?

CodePudding user response:

Use regxep_like can realize,

CodePudding user response:

Drinking coffee outside ~

CodePudding user response:

Correct the table a value can have multiple keywords, middle & amp; Separately, not necessarily is two,

CodePudding user response:

 SELECT * 
The FROM B 
LEFT the JOIN A 
ON REGEXP_COUNT (Dr. ALUE, '& amp; ') + 1=
REGEXP_COUNT (B.R EMARK, REPLACE (Dr. ALUE, '& amp; ', '|'))