Suoritettu

run a query in SQL

I have a table called "customers" in a database... i have a field in this table, called "zip_code"

zip_code varchar(255) utf8mb4_unicode_ci

zip code should be always 5 character... like "08001" or "28001" or "42001"

But i have certain cases were the field have been filled with only 4 character.. as "1001", "8901" or "1234"

I dont now how to write the sql sentence for this:

For all the data points in the field "zip_code" of the table "customers" with only 4 characters... add a "0" in the first place...

ie...

if the data is 8001... it should be 08001...

if the data is 1234 it should be 01234

taking care that there might be 28001 and 41234 that sould not be changed because they already have 5 characaters...

so i need the text to Run SQL query on table [login to view URL]:

Taidot: SQL, MySQL, Microsoft SQL Server, PHP, SQLite

Näytä lisää: sql query remote database mysql, sql database size query, clone sql database query, sql query sql database size, sql query remote database, sample sql database query form, input form query sql database, write sql query parent child relation tables database, sql database query visual basic, vbscript query sql database csv, word vba sql database query, windows gadget query sql database, write sql query joins tables example database uses, matlab query sql database gui, sql query access database, create a sql database and create a simple but good looking website where i can access and query the database, query form sql database to show in textboxs c#, query form sql database to show in textboxs c, query access database from sql server

Tietoa työnantajasta:
( 47 arvostelua ) Sevilla, Spain

Projektin tunnus: #31015260

Myönnetty käyttäjälle:

AmirKhaled29

i wont talk to much your task is too much simple as much as you can imagine just contact me and i'll do in minutes

€14 EUR 1 päivässä
(0 Arvostelua)
0.0

27 freelanceria on tarjonnut keskimäärin €19 tähän työhön

(342 arvostelua)
7.9
vladang

Hello sir/madam... I can add 0 in front of ZIP code. Please, contact me to make deal Regards Vladimir

€20 EUR 1 päivässä
(137 arvostelua)
6.6
(144 arvostelua)
6.1
xGabryMC

Hi, you could run this to check if the "where condition" is correct: SELECT * FROM [login to view URL] WHERE LENGTH(zip_code) = 4 then to update and pad the string with a leading 0 at the beggining use UPDATE petpla Lisää

€25 EUR 1 päivässä
(20 arvostelua)
5.0
(20 arvostelua)
4.6
aodinaev000

Hi there. I am professional full stack web developer. I will be glad to help you. Please check my profile. Thanks.

€30 EUR 1 päivässä
(13 arvostelua)
4.3
fugus

Hello, I am an expert in database management and administration. I specialize in MYSQL, ORACLE and Postgress. I can work on your work ASAP. Come over the chat we discuss more. Thank you

€20 EUR 1 päivässä
(22 arvostelua)
3.9
livenow267

Hi, Based on your description, I see you are looking for a developer who can start your project immediately. I am a senior web developer with extensive development background. I have more than 5 years of development ex Lisää

€19 EUR 7 päivässä
(18 arvostelua)
4.1
hoaxuyentri

Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuy Lisää

€12 EUR 1 päivässä
(15 arvostelua)
3.9
adricabrelles

Hola Soy un DBA de Valencia con más de 20 años de experiencia en Oracle, sql server, mysql , .... consultas sql. Te puedo ayudar con tu consulta. Saludos.

€20 EUR 7 päivässä
(17 arvostelua)
4.2
anandan1995

I have a experience in asp.net, MVC, web API,Laravel,Php,,Java, Spring mvc,Hibernate, c#, SQL, entity framework,linq, razor view (Cshtl), html, Wordpress,Joomla,Shopify,Jstl,bootstrap,Angular JS, Jquery, Json,XML, repo Lisää

€29 EUR 1 päivässä
(15 arvostelua)
3.7
bohdansmoliar

Hi, I am a sql expert who has 5 years of experience. I can do this quickly. I would like to discuss more via chat. Thank you.

€20 EUR 1 päivässä
(5 arvostelua)
3.7
rjramanayake

SQL expert here. Can complete your task within 30 minutes. Please feel free to contact me and discuss further. High quality work will be returned meeting your deadline and budget, follow up work and support is guarant Lisää

€15 EUR 1 päivässä
(10 arvostelua)
3.2
gryndanya

SQL developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks

€30 EUR 2 päivässä
(15 arvostelua)
3.1
nadezhda319

Dear Client. Hope you are doing well. ⭐⭐⭐I am SQL expert.⭐⭐⭐ High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I am a full-stack developer who has rich experience in web devel Lisää

€30 EUR 1 päivässä
(4 arvostelua)
2.2
(4 arvostelua)
2.3
GeorgeP1979

Hi there! I can help you with your script. Which database are you using? MySql? If you assign me the task I can start working right now. Thanks, George

€10 EUR 1 päivässä
(2 arvostelua)
1.6
jyotit371

Hello , there I have read your requirements. I have 5 + years of experience in same technologies c#, asp.net, jQuery and MySQL, SQL server I will do my best to deliver you quality of work on time . Please give me one Lisää

€10 EUR 7 päivässä
(1 arvostelu)
1.7
dsinfoways

Hello Sir, I have gone through your requirements regarding run a query in SQL. we brief and understand your idea and preference for job as you are looking for. I have more than 10+ years of experience in .NET, .NET C Lisää

€19 EUR 1 päivässä
(0 arvostelua)
0.0
vslav9966

Dear Client. Share with me your sql file if you possible. I am a SQL expert for over 15 years. I am able to start right now once we agreed all, and you will get a perfect query in a few hours. Looking forward to worki Lisää

€15 EUR 3 päivässä
(1 arvostelu)
0.0