MySQL Task - Remove Records With More Than 126 Characters in a specific field

$2-8 USD / hour

Terminado

Publicado

hace más de 9 años

$2-8 USD / hour

Task: Remove all records with more than 126 Characters in a specific field. SQL DB Dump will be provided 5 STAR FEEDBACK WILL BE LEFT. You must be able to start work immediately and complete within an hour. Time: less than 1 Hour

MySQL

ID del proyecto: 6353581

Información sobre el proyecto

10 propuestas

Proyecto remoto

Activo hace 10 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@brainwithstorm

Here you have the query: SELECT * FROM table_name WHERE LENGTH(field_name) > 126; This how you will have all records visible that has certain field >126. If you want to delete them just use DELETE FROM table_name WHERE LENGTH(field_name) > 126 --> Simple as that :)

$8 USD en 1 día

5,0

(41 comentarios)

5,0

10 freelancers están ofertando un promedio de $12 USD /hora por este trabajo

@FandaR

A proposal has not yet been provided

$22 USD en 1 día

4,9

(206 comentarios)

6,6

@amcorreia

Hi, i can do it. .

$33 USD en 1 día

4,7

(40 comentarios)

5,8

@ergo1wish

Hell, I can start now and I can finish this in max 5min. If you are interested contact me here on freelancer.

$8 USD en 1 día

5,0

(7 comentarios)

4,8

@linuxpakistan

Hello, I can do this work and all i need to know that you want to remove complete records which have more then 126 Characters in your mentioned fields. Thank you.

$5 USD en 1 día

5,0

(29 comentarios)

4,3

@gcStudioOrg

Hello, i can do just that. I can start right away & finish within the time that you have specified. Please message me so i can start right away. Best regards

$6 USD en 1 día