Mysql Limit Offset not working -

here query, using pagination

select distinct email_list.*, email_counter.phone e_phone,email_counter.email e_email,email_counter.marketing e_marketing    data_tls_builders email_list  left join wp_pato_email_list_counters email_counter on email_counter.email_id = email_list.urn     limit 120 offset 150 

rather starting @ 120 , finishing @ 150, should display 30 results, mysql returning 120 results , ignoring offset. have tried limit 120,150 , still same?

any idea how solve?

select distinct email_list.*, email_counter.phone e_phone,email_counter.email e_email,email_counter.marketing e_marketing data_tls_builders email_list left join wp_pato_email_list_counters email_counter on email_counter.email_id = email_list.urn limit 30 offset 120 

limit specifies number of records.

offset specifies upto how many records should skip.

the above query returns 30 records 121.