how to get result form mysql query in specific ids [closed]

by

Change your query to say you want an id greater than the number you’re looking for – 

 "SELECT * FROM category WHERE id > '10'"

More Related Contents:

  1. How to return rows that have the same column values in MySql
  2. How to join two tables mysql?
  3. SQL table with “list” entry vs SQL table with a row for each entry
  4. Storing JSON in database vs. having a new column for each key
  5. How do I restore a dump file from mysqldump?
  6. How to handle fragmentation of auto_increment ID column in MySQL
  7. MySQL – Conditional Foreign Key Constraints
  8. Groupwise maximum
  9. What effects does using a binary collation have?
  10. Are dynamic mysql queries with sql escaping just as secure as prepared statements?
  11. MySQL automatically cast/convert a string to a number?
  12. How to select rows that have current day’s timestamp?
  13. MySQL concatenation operator
  14. What’s the best database structure to keep multilingual data? [duplicate]
  15. LEFT JOIN only first row
  16. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  17. Using an IF Statement in a MySQL SELECT query
  18. MySql – Way to update portion of a string?
  19. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  20. MySQL connection over SSH tunnel – how to specify other MySQL server?
  21. Storing IPv6 Addresses in MySQL
  22. Insert/ Update random date in MySQL
  23. How to determine which database is selected
  24. How to remove constraints from my MySQL table?
  25. Defining Composite Key with Auto Increment in MySQL
  26. How to use Table output from stored MYSQL Procedure
  27. Get total hours worked in a day mysql
  28. MySQL errorno 121
  29. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment