mysql concat two columns if

Question

I have database table which contains two columns "url" of type varchar and "www" of type tinyint which contains 1, if url was specified with www prefix, and 0, if not.

I want create a column in mysql view called full url which would contain following equivalent of c++ code:

full_url = "http://" + (www == 1 ? "www." : "") + url;

Can you help me?

Alex Kleshchevnikov · Accepted Answer · 2014-03-23 11:05:06Z

2

SELECT CONCAT('http://', IF(www = 1, 'www.', ''), url) AS full_url FROM table

answered Mar 23, 2014 at 11:05

Alex Kleshchevnikov

3646 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

M Khalid Junaid · Accepted Answer · 2014-03-23 11:07:15Z

0

You can use CASE

SELECT
(CASE WHEN www == 0 /*if not specified with www then add www*/
THEN CONCAT('http://','www.',url) 
ELSE CONCAT('http://',url) /*url contains www*/
END ) `url`
FROM ...

answered Mar 23, 2014 at 11:07

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Collectives™ on Stack Overflow

mysql concat two columns if

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related