MySQL – This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery

by

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

More Related Contents:

  1. Im trying to create some temporary tables in mysql using php
  2. the update query just update the last row and affect other with it’s value
  3. How to insert images into a database using PHP [closed]
  4. How to change mysql to mysqli?
  5. php mysqli_connect: authentication method unknown to the client [caching_sha2_password]
  6. Sum values of multidimensional array by key without loop
  7. Get sum of MySQL column in PHP
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. Laravel 5 PDOException Could Not Find Driver
  11. Escaping MySQL wild cards
  12. Import CSV file directly into MySQL
  13. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  14. Using MySQLi from another class in PHP
  15. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  16. Increment value in MySQL update query
  17. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  18. What is the advantage of using try {} catch {} versus if {} else {}
  19. Javascript function post and call php script
  20. Trying to access array offset on value of type bool
  21. onbeforeprint() and onafterprint() equivalent for non IE browsers
  22. How to get a query error from prepare() in PDO PHP?
  23. Fatal error: Call to a member function query() on null
  24. MySQL GROUP BY and Fill Empty Rows
  25. mysql injection damages?
  26. PHP PDO how to run a multiple query request?
  27. Select mySQL based only on month and year
  28. Mysql InnoDB engine in Laravel
  29. MySQL: Group by two columns and sum
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment