Home > database >  Consult bosses: a field contains multiple strings, how to query. There are three kinds of situation.
Consult bosses: a field contains multiple strings, how to query. There are three kinds of situation.

Time:09-24


1, when the T1 table and form M1 departments are the same, and T1. The researchers included in M1. Personnel within, query the T1 form, keywords,

M1
Department personnel
A 1,3,5,6,9
6, 8 C


T1
Department personnel matters keyword
A 1, 5 XXXX character
B level 5, 9 BBBB
A, 3, 7 CCCC gender AD

2, when the T2 form and M2 form departments, same T2. The workers have at least two in the M2. The personnel, the query T2 form, keywords,

M2
Department personnel
A 4,5,6,8


T2
Department personnel matters keyword
A level 2,4,5,7,9 XXXX

3, when the T3 form, department and N3 form, M3 form is the same, T2. Personnel 1 included in N3. Personnel, T3. Personnel 2 included in M3. Personnel, query T3 table, keywords,

N3
Department personnel
A 1,3,4,6


The M3
Department personnel
A 2,5,7,9


T3
Personnel department personnel 1 2 item keyword
A 1 2 XXXX character
B 2 5 BBBB
A 4 3 CCCC couples


  • Related