run a query in SQL
€8-30 EUR
Paid on delivery
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]:
Project ID: #31015260
About the project
Awarded to:
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
22 freelancers are bidding on average €19 for this job
Hello sir/madam... I can add 0 in front of ZIP code. Please, contact me to make deal Regards Vladimir
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 More
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
Hi there. I am professional full stack web developer. I will be glad to help you. Please check my profile. Thanks.
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 More
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.
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 More
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.
SQL developer experience over 4 years I can start working immediately. Let's discuss details in chat. Thanks
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 More
I will write the sql and send it immediaty. if you need further tweaking in case if you want to improve your scenario, I will do it in the same job.
welcome My Dear I can do that in short time you can talk with my and make this query and another query any time you need
Dear Customer, I am also a qualified and highly experienced for SQL so you won't have to worry about the quality of my work. Please trust me. I am looking forward to working with you on your project and achieving your More
I can write the query for you. I have very good knowledge on SQL Server. Please ping me I can give you the query within minutes.
Hi I have good experience in sql and I can finish it right away in minutes. Please give me a chance to finish work