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

Habilidades: ASP, PHP

Veja mais: 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, purple, Project m, pink, parsed, null

Acerca do Empregador:
( 1 comentário ) Chelmsford, United States

ID do Projeto: #128722

Concedido a:


I can do it easyly. Check pm plz

$110 USD em 1 dia
(1 Comentário)

7 freelancers estão ofertando em média $137 para esse trabalho


Hi, Pls. check PMB. Thanks

$150 USD em 1 dia
(124 Comentários)

i can help you

$200 USD em 1 dia
(29 Comentários)

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

$100 USD em 1 dia
(14 Comentários)

plz check pmb.

$100 USD in 0 dias
(7 Comentários)

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

$200 USD em 1 dia
(1 Comentário)

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

$100 USD in 4 dias
(0 Comentários)