MySQL table -> Can you return the same row multiple times, in the same query?

by

You would have to do something like this:

SELECT * FROM menu WHERE item_id = 1
UNION ALL
SELECT * FROM menu WHERE item_id = 1
UNION ALL
SELECT * FROM menu WHERE item_id = 2

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. MySQL – ERROR 1045 – Access denied
  10. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  11. Difference between float and decimal data type
  12. Convert timestamp to date in MySQL query
  13. Parse date in MySQL
  14. mysql dynamic query in stored procedure
  15. mysql: get record count between two date-time
  16. LOAD DATA INFILE Error Code : 13
  17. Table is ‘read only’
  18. How to select one row randomly taking into account a weight?
  19. auto_increment by group
  20. Proper database model for a user feedback system (an interesting case)
  21. MySQL Errno 150
  22. MySQL – Replace Character in Columns
  23. Sort the rows according to the order specified in WHERE IN clause
  24. How do you manage databases in development, test, and production?
  25. MySQL distinction between e and é (e acute) – UNIQUE index
  26. MySQL OPTIMIZE all tables?
  27. What’s mysql’s “BETWEEN” performance over..?
  28. Deleting a row based on the max value
  29. mysql double-quoted table names
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment