i have a two table
1- myusers: id name ...
2- mygroup id idusers
and idusers impload idusers with , !
example : id1,id2,id3
i want check all mygroup Field And Delete id no exist in myuser
please Help me
Asked
Active
Viewed 35 times
-2
Mehul Kuriya
- 608
- 5
- 18
Mahdi
- 11
-
1did u tried anything? plz share – devpro Nov 03 '16 at 09:18
-
i haven't any idea For this Task :( – Mahdi Nov 03 '16 at 09:26
-
u must need to share the both table structure – devpro Nov 03 '16 at 09:27
-
JUST table1:Myuser : id AND table2:mygroup:id,idusers – Mahdi Nov 03 '16 at 09:50
1 Answers
0
Please Use "FIND_IN_SET" mysql that will find value in comma separated value.
For more detail you can find below link http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php
Dhaval Bhavsar
- 495
- 5
- 17