How do select random record from a specific table when using join query? I have below two table and I will like to select random pid
Users
id | name. | uid
-----|--------|-----
1 | Peter | p1
2 | Hana | p3
3 | John | p4
4 | Joe | p2
Packages
pid | tag | puid
-----|----------|------
1 | PHP | p1
2 | JAVA | p1
3 | CSS | p2
4 | SQL | p1
5 | PYTHON | p3
6 | HTML | p1
7 | SWIFT | p1
Query
SELECT u.*, p.*
FROM users u
INNER JOIN packages p
ON u.uid = p.puid
WHERE u.uid = "p1"
ORDER BY RAND()
LIMIT 2
Aucun commentaire:
Enregistrer un commentaire