SQL project

I have a mySQL .SQL data file which needs some cleaning up, with a script (not manually).

What needs to be done:

1) The 'Details' field is currently a messy aggregation of five information fields.

Color, Size, Fabric, Weight, Producing Time


a) 'COLOR:pink,green,purple,bluernSIZE:s,m,lrnFABRIC:100%cottonrnWEIGHT:[url removed, login to view]'

b) 'Color:blue,size:S,M,L,Fabric:100%cotton,weight:[url removed, login to view],ProducingTime:7days'

The table needs to be redefined and this field needs to be parsed/split out into the 5 separate fields.

2) There are some spelling errors and typos within the fields. I need the unique values (groupBy) list of each field so I can provide input on what needs to be cleaned up/reconciled to an approved list of Correct values. Then you need to be able to apply that 'correct list' to the data.


Here is the current [url removed, login to view] and there are 13000 records in the table.

This is the [url removed, login to view]

create table products (

id int not null,

offer_no varchar(32),

brand varchar(32),

category varchar(32),

subcategory varchar(32),

quantity int not null default 0,

quantity_min int not null default 0,

price varchar(32),

style varchar(32),

weight varchar(32),

details tinytext,

image_1 varchar(128),

image_2 varchar(128),

image_3 varchar(128),

image_4 varchar(128),

primary key (id))

pm for more details

Beceriler: ASP, PHP

Daha fazlasını gör: sql price, sql create table price, project details example, php script null, php price project, int size c, int i, create category and subcategory in php, Cotton on, blue cotton, split sql file, on sql, sql, sql script , sql project , sql mysql, sql l, sql data, sql c, sql and c

İşveren Hakkında:
( 1 değerlendirme ) Chelmsford, United States

Proje NO: #128722



I can do it easyly. Check pm plz

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)

Bu iş için 7 freelancer ortalamada $137 teklif veriyor


Hi, Pls. check PMB. Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(124 Değerlendirme)

i can help you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(29 Değerlendirme)

I can make the script to cleanup your database. Thanks :)

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)

plz check pmb.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

Hi, I can do this for you in 1 day. Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

I want to do the project with quality, therefore I'll require atleast 4 days in completing. I have expertise in MySQL.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)