This might as well: https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
James E. Thomas Enterprise Practice Support Systems Manager Baker Botts L.L.P. [email protected]<mailto:[email protected]> T +1.713.229.2196 F +1.713.229.8130 M +1.832.373.8117 910 Louisiana Street Houston, Texas 77002 USA [bblogo]<http://www.bakerbotts.com/> [linkedin]<https://www.linkedin.com/company/baker-botts-llp?trk=hb_tab_compy_id_8300> [youtube] <https://www.youtube.com/channel/UCgys2C8DwRY-BVN079QNnwQ> [facebook] <https://www.facebook.com/BakerBottsLLP/> [instagram] <https://www.instagram.com/bakerbotts/> [twitter] <https://twitter.com/bakerbotts> From: [email protected] [mailto:[email protected]] On Behalf Of Mike Gillespie Sent: 22 March, 2018 7:05 PM To: Houston ColdFusion Users' Group <[email protected]> Subject: [houcfug] SQL Query help Hey y'all, Sure hope you can help with this one. Is there a way to write a sql query for MySQL such that it returns recordset of say 100 rows with my target recordset in the center from a table of 1000 rows? I need it to load a page of items on an ecomm site, but want to provide not only the target item, but 100 other choices as well. The number 100 and 100 are arbitrary. Basically, pull all records with a price range between .99 and 9.99 with the 4.99 target row in the center of the resultset. ( and yeah, the example is horrible, but it gets the point across) TIA, M -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected]<mailto:[email protected]> For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. -- -- You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en --- You received this message because you are subscribed to the Google Groups "Houston ColdFusion Users' Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
