Help database query problem ...

helium

There is a data table similar to the following.
Table I.
ID1 Name KeyId
1 a1 2 | 22 | 3 | 5
2 a2 5 | 22 | 33 | 1
3 a3 8 | 10 | 2 | 1
4 a4 9 | 10 | 11 | 22
5 a5 2
Table II
ID2 text
1 123
2 456
3 789
4 1112

The KeyId stores the IDs of Table 2 separated by "|" characters. Assuming that Table 2 has ID2 = 2, select the record with KeyId 2 in Table 1.
Conversely, if there is no 2 in KeyId, write 2 in it and separate it with "|".

Ask everyone to point out the code.

jadekylin

Modify Table 1 to
ID1 Name KeyId
1 a1 2,22,3,5
2 a2 5,22,33,1
3 a3 8,10,2,1
4 a4 9,10,11,22
5 a5 2

Everything is solved

yuke1988

$KeyId=split('|',$rs);
if(!array_key_exists($ID2,$KeyId)) $rs.='|'.$ID2;

helium

How to write SQL statements changed to "," or "|"?

helium

What should I do if there is 2 in KeyId?

helium

$KeyId=split('|',$rs);
if(!array_key_exists($ID2,$KeyId)) $rs.='|'.$ID2;


It seems that even 22 is included.

qijun2005

Well, use a comma.

ivanor

select find_in_set(2,KeyId) from Table 1

Change | to, so that you can find out which has 2 and which does not, and then perform the operation you want