mySQL select multiple ids December 18, 2009 • 19 words • 0 min read • Updated Apr 23, 2026 #MySQL SELECT * FROM tablename WHERE `active`='1' AND `id` IN ('107' , '125' ) ORDER BY `id` DESC LIMIT 12` Andrew Odendaal Writing about cloud architecture, DevOps, distributed systems, and software development since 2007. About this site → Related Articles Create a slug from a name in MySQL/MariaDB Aug 2023 How to Change a MariaDB/MySQL Data Directory to a New Location on Linux Mar 2023 How to count the amount of rows in MariaDB fast Feb 2023 How to Join Multiple MySQL Tables in Python Aug 2022 How to Limit a MySQL Query in Python Aug 2022 How to Update a MySQL Table in Python Aug 2022 How to Drop a MySQL Table in Python Aug 2022 How to Delete MySQL Records in Python Aug 2022