In the database ALL the cities are in the wrong columns

Hello, I guess structure like this because of seo purposes. Maybe it's better to fix php codes. I can check it if you give me access.

I fixed your error already. Ping me. I'll help you. Dear hiring manager. Reading your job description, I am so interested in your job and confident to your project. I have extensive experience in developing several dynamic websites, and I am an expert in PHP and Javascript. As a full-stack web developer, I can cover back-end successfully as well using php frameworks such as CI, Laravel, wordpress, Magento, Magento 2 and Javscript frameworks such as Node/ExpressJs and ROR or Django with strong background in a variety of database platforms such as mysql, postgresql, mongodb, elastic search. Expecially, I am familiar with the website development with php. So I think that your project is a good fit for me. If you hire me, I will wrap up it perfectly within the shortest time. Looking forward to working with you. Best Regards. Fang G.

Hello. I am web and mobile expert with 3+ years exp. I am interested in your query work. Please let me discuss with u in detail. Thank you.

Hello, As an expert in MySQL, i am very much interested to fix this issue. I am available now to do it. If you want, i can fix the sql file and return back to you. Thanks

yes sure I can help you now.

sir message me i will fix this now ... sir message me i will fix this now ... sir message me i will fix this now ...

Hi There, I can fix database issue. I can migrate data as per your requirement to other specific column. Looking forward. Thanks

Hello, I’ve just read your job posting and I’m interested. I am hard worker and dedicated freelancer. Please check my profile and portfolio. I’d be happy to keep long partnership, if you’d like. Looking forward for you kind response. Best Regards,

Hi, In the insert query just swap the column names, it will work. we can update the city names in the db. Can you ping me to discuss more? I am interested in the project and have an experience in it. thanks

Hi Hope you are doing well.I have 7yrs of experience on web developement with various assignment completed successfully and looking forward for many more.I have good exposure in php mysql html css javascript jquery ajax website scrapping.

Hi, I saw your DB but what you want to do ? change the name of columns, or move cities to other columns ??? contact me now if you want I am available.

Hi, Hope you are having a good time. I understand your requirement. so please send me details and lets start your project as soon as possible. Thank You

I can move the data from the current column to which ever column you want. I have prior experience with mysql data migrations. we can even make setup to replicate this data across columns if required.

Hi, I always prefer to work in MySQL. I usually use MySQL as my database software. I can do it for you in no time

Hi, As far as I understand, you would like values for columns name and cityName to be interchanged. That's easy thing to do and I can send you fixed SQL file in an hour after the project is awarded. If you have any questions related to my experience or anything else, you're always welcome to ask. I'm looking forward to hearing from you. Best regards, Andrius

Hello, Irish developer here I can sort out the names in your "name" column to be correct like you've asked. As demonstrated I've read your spec and I have a Computer science degree with 8 years experience.. I can get this done today starting immediately. Send me a message if your interested. Kind regards Ryan

Hello, I have checked your concern and would love to help you out. I have experience with both with RDBMS(MySQL and Microsoft SQL) and ORDBMS(Oracle). Thanks for your consideration.

Hello sir, I am database expert and I can solve your issue. We can simply remove space. While searching so the value will b match to database value. Thank you Best regards Neeraj Agrawal

Hi! This is my first time to do such job. I'm a beginner at doing freelance. But I'm a data analyst for years now. And SQL is kinda my asset. I would love to learn to do such things that's why my cost is very low. I would love to use this as my personal experience to grow as an sql user. :)

let me know that all cases are like that or else i have good SQL query ,views,procedurefunction,triggers knowdge and experience in MYSQL