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,198,228
  • 53
  • 572
  • 709
Computer Im
  • 85
  • 1
  • 10

0 Answers0