dimanche 14 novembre 2021

Mysql random record using join

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