# How to customize Query?

**URL:** <https://forums.percona.com/t/how-to-customize-query/981>\
**Category:** Other MySQL® Questions\
**Created:** [October 29, 2008, 1:15am UTC](https://forums.percona.com/t/how-to-customize-query/981 "2008-10-29T01:15:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hakeem](https://avatars.discourse-cdn.com/v4/letter/h/c2a13f/32.png) [@hakeem](https://forums.percona.com/u/hakeem)\
**Post date:** [October 29, 2008, 1:15am UTC](https://forums.percona.com/t/how-to-customize-query/981/1 "2008-10-29T01:15:56Z")

</div>

hello guys,

i have the following users on mysql table

yahoo  
google  
hotmail  
gmail  
mail  
web

I want to select the first 2 record(yahoo, google), and next 2(hotmail, gmail),  
and last 2 (mail, web) please how do i write the query.

---

<div class="post-metadata">

**Author:** ![artur8ur](https://avatars.discourse-cdn.com/v4/letter/a/9f8e36/32.png) [@artur8ur](https://forums.percona.com/u/artur8ur)\
**Post date:** [November 4, 2008, 10:11am UTC](https://forums.percona.com/t/how-to-customize-query/981/2 "2008-11-04T10:11:01Z")

</div>

Do you mean something like this?  
SELECT \* FROM users ORDER BY name LIMIT 0,2  
SELECT \* FROM users ORDER BY name LIMIT 2,2  
SELECT \* FROM users ORDER BY name LIMIT 4,2