79238033

Date: 2024-11-29 18:23:17
Score: 0.5
Natty:
Report link

IN operator doesn't parse comma separated values within a field like 1,2,4

select t1.idTable01, t1.fieldData01, 
t1.fieldData02 from Table01 t1 join 
Table02 t2 on t1.idTable01 = 
t2.idTable02 where 
FIND_IN_SET(t1.fieldData02, t2.Field01) 
> 0 and t2.idTable02 = 1;
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Marwen Jaffel