MySQL Concatenate ROWS, IF Conditions.

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

I have 3 columns you need to work with

1. Site

2. Site address.

3. Oneway

I just need you to do two things.

1. Create a Query like If conditions

Example: If Site column = "1" Site address must be = "ONE"

(This can go Up to 18 Loops)

2. Concatenate two columns + Text

Oneway column must be:

"You need to go to: *SiteAddressColumn*

Note: The IF Conditions and Concatenate must be applied to ALL ROWS in Oneway Column and Site address column.

MySQL SQL SQLite

Project ID: #11089704

About the project

29 proposals Remote project Active 7 years ago

29 freelancers are bidding on average $16 for this job

gslogics123

Hello Sir Can we discus in details? I am available via chat as well to discuss the issue. Please check my profile for work and experience. Regards Ashwin

$25 USD in 0 days
(82 Reviews)
6.2
vinaysinghh

A proposal has not yet been provided

$25 USD in 1 day
(55 Reviews)
5.2
NeaWeaR

Hello my dear friend! I can help with your project. I am experienced (4 years) frontend+backend developer with such stack of technologies: HTML, CSS, Bootstrap, JS (JQuery, svg, 3d, etc.) PHP, Wordpress, Yii, More

$30 USD in 1 day
(12 Reviews)
4.9
phiona06

Hi* I'm senior lecturer on databases. I'll create your queries fast, it's really four-five rows of code.

$10 USD in 0 days
(28 Reviews)
4.7
sanjayahlawat1

Sir, I can do this project .Message me to discuss. My goal is to provide best service for my clients in minimum possible amount. I will accept projects only when i'm 100% sure. Thanks! :)

$10 USD in 1 day
(24 Reviews)
4.4
point5nyble

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in More

$30 USD in 1 day
(29 Reviews)
4.6
davedcb

Hello, I am interested in your project. I am software engineer and I have profissional experience with SQL. Thank you, Best regards, David

$10 USD in 1 day
(23 Reviews)
4.1
marko04

Hi , it's very easy . I can do it very fast , just give me some examples of tables , or better database. It can be solved with one or two select queries. Hope to contact me.

$12 USD in 1 day
(5 Reviews)
3.7
AntonBliznetc

I do that in 1 hour I am a full time programmer with 20 year exp in Russia. I have hi degree in information system in economics.

$35 USD in 0 days
(16 Reviews)
3.5
hotuanthanh

I have experienced in SQL for more than 6 years and I believe that I can afford your requirements. Could you pay me directly on Paypal?

$10 USD in 1 day
(2 Reviews)
3.2
andyborrero

hello, im DBA with experience working with MySQL, PostgreSQL, MSSQL. i think i can help you. i will be in chat.

$15 USD in 2 days
(3 Reviews)
2.3
freeearth

I have an experience with complex mysql queries such as join, strored procedures, switch. So I'can help you.

$15 USD in 1 day
(1 Review)
1.9
eXtolTech

We already did many projects of this type, i can deliver you solution in 1 hour. Inbox me if interested . . . Waiting for you message . . .

$10 USD in 1 day
(0 Reviews)
0.0
sylice

A proposal has not yet been provided

$15 USD in 1 day
(0 Reviews)
0.0
fertroya

A proposal has not yet been provided

$20 USD in 1 day
(0 Reviews)
0.0
emilianofeijoo

A proposal has not yet been provided

$17 USD in 1 day
(0 Reviews)
0.0
JimmyDo

I used to work with Mysql to create procedure for collecting report data for complicated report

$15 USD in 1 day
(0 Reviews)
0.0
anjanajkanzariya

hi I've a strong hand in SQL. I have worked to make efficient procedures for faster execution of queries and use normalisation in tables so as to minimise redundancy. I've also worked with User defined functions and t More

$12 USD in 1 day
(1 Review)
0.0
Jolejbg

Hello my name is Jovan and I'm a bachelor in Computer Science and Mathematics. I have 3 year experience in Java/ C++/ C, Android and Opengl ES. I am very familiar with low level development such as OpenGl, C, C++ and a More

$15 USD in 1 day
(0 Reviews)
0.0