0

I use below code but not work

SELECT `oldTb`.`userId`
FROM `user` AS oldTb JOIN
     `user` AS newTb
WHERE `newTb`.`userPrivate` LIKE "%,`oldTb`.`userId`,%"
GROUP BY `userId`

Actually, i want get result of users when userPrivate column have ,ID, of users from self table

Example:

userId ---- userPrivate    
1  ---- ,0,    
2 ---- ,0,    
3 ---- ,1,    
4 ---- ,1,3,    
5 ---- ,3,

Now have to result is :

1 and 3

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
Computer Im
  • 85
  • 1
  • 11

0 Answers0