query used to partation table into many table in mysql
===

am having mysql table .it contain 22 crores of data .the table contain 5 columns like


    table columns
    -------------
    fld_opstype	char(5)
    fld_phonenumber	varchar(15)
    fld_phonetype	char(5)
    fld_preferences	char(5)
    fld_serviceareacode	varchar(5)

 
the column fld_preferences column contain value like 0,6, #1#2#3

    my question is how to partation the table into 5 or more table based on the  fld_preferences (with  condition like fld_preferences=0).please help me to do this?(using mysql workbench)