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

$2-8 USD / hour

Completed

Posted

over 9 years ago

$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

Project ID: 6353581

About the project

10 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

5.0

(41 reviews)

5.0

10 freelancers are bidding on average $12 USD/hour for this job

@FandaR

A proposal has not yet been provided

$22 USD in 1 day

4.9

(206 reviews)

6.6

@amcorreia

Hi, i can do it. .

$33 USD in 1 day

4.7

(40 reviews)

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 in 1 day

5.0

(7 reviews)

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 in 1 day

5.0

(29 reviews)

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 in 1 day