Mysql – Select + update query in the same table
I am using MariaDB and I am trying to create a query that updates the boolean column is_popular of my photos table, called Pics. To find out which photos are "popular", I pick the top 10 from the entire table.…