Completed

modify contents of MySQL table

I have a MySQL table with approximately 10,000 records. In one field, the field_billingaddress_value, there is content like 1415 6th Ave N, 204. This is a set of values followed by a comma followed by a 3 or 4 digit number.

Some records do not have a comma or data following the set of values.

I need to have the comma and all data after the comma deleted from the field_billingaddress_value where it exists so the set of values before the comma are untouched. If there is no comma, the field is untouched.

In some cases, the data looks like 1585 Broadway, FL 10\n, in this case, the comma and everything after it should be removed.

The deliverable is to provide the SQL command or stored procedure which will check all records in this table and remove the comma and data after the comma when they exist. While I am providing the file for you to test with, I will run the deliverable on my server.

The data file is attached.

Habilidades: MySQL

Ver más: contents of a will, table of content, ave, sql table remove, mysql number sql, 204, mysql remove table, sql server command, mysql exist table, table exist, table content, mysql table exist, modify procedure, test sql command, mysql modify, procedure mysql, mysql procedure file, mysql procedure, mysql stored procedure, data comma mysql

Información del empleador:
( 168 comentarios ) Seattle, United States

Nº del proyecto: #3724432

Adjudicado a:

skysword

See private message.

$21.25 USD en 1 día
(30 comentarios)
5.0

6 freelancers están ofertando el promedio de $48 para este trabajo

ian11

See private message.

$127.5 USD en 1 día
(37 comentarios)
5.4
grupociberia

See private message.

$80.75 USD en 1 día
(49 comentarios)
5.4
netcometvw

See private message.

$35.7 USD en 1 día
(16 comentarios)
5.2
ajitsg

See private message.

$8 USD en 1 día
(17 comentarios)
3.9
cocofida

See private message.

$13 USD en 1 día
(0 comentarios)
0.8