"mysql - this version of mysql doesn't yet support 'limit & in/all/any/some subquery" Code Answer

3

Instead of using IN, you can use JOIN

SELECT v.VID, v.thumb
FROM video AS v
INNER JOIN
     (SELECT VID
     FROM video
     WHERE title LIKE "%'.$Channel['name'].'%"
     ORDER BY viewtime DESC
     LIMIT 5) as v2
  ON v.VID = v2.VID
ORDER BY RAND()
LIMIT 1
By jameesadam986-ca8cfcbab345 on October 30 2022

Answers related to “mysql - this version of mysql doesn't yet support 'limit & in/all/any/some subquery”

Only authorized users can answer the search term. Please sign in first, or register a free account.