I think we cant do it in mysql. Because of string 'S'. But found some link if id is number http://stackoverflow.com/questions/1389605/sql-find-missing-ids-in-a-table
But we can do it with some scripting language like ruby or python to solve the issue. Getting all ids and generate ids of array from (S001.. S00N) and compare those array. May be its not best solution. But we can achieve through some scripting language. On Mon, Jul 22, 2013 at 7:21 PM, Siva prabu <gsivapr...@gmail.com> wrote: > My table:- > > +-------+ > webno > -------+ > > |S001| > |S002| > |S003| > |S005| > |S006| > |S009| > |S010| > > > How to find the missing numbers in the Column webno for the series....... > > > i need like > > > ****** > S004 > S008 > > ****** > > > ** > > * regards, * > > *| Sivaprabu. G **|* > > * |*ABOUT~ME <http://about.me/gsivaprabu>* **|* > ** <http://about.me/gsivaprabu> > _______________________________________________ > ILUGC Mailing List: > http://www.ae.iitm.ac.in/mailman/listinfo/ilugc > ILUGC Mailing List Guidelines: > http://ilugc.in/mailinglist-guidelines > -- ------------------------------------------------------------------------------------------ Regards sathia Here I share my experiments with open source. http://www.sathia27.wordpress.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc ILUGC Mailing List Guidelines: http://ilugc.in/mailinglist-guidelines