mysql generating dynamic url using id of the table

Question

I need to generate the dynamic url by getting the id of table and other fields. but for this url i need only id

my query is working but i need the id value for every record in this [CARD ID] http://mysite.com/webaplication/postcard/view?id=[CARD ID]&shared

SELECT
            `user`.`first_name` 'First Name',
            `user`.`last_name` 'Last Name',
             CASE `card`.`shared` WHEN 1 THEN 'http://mysite.com/webapplication/card/view?id=**`card`.`id`**&shared' ELSE 'No URL' END 'URL',   
            `card`.`created` 'Created', 
            CASE `card`.`shared` WHEN 1 THEN 'Yes' ELSE 'No' END 'Shared'

        FROM
            `user`, `card`
        WHERE `card`.`id` =`user`.`id`
        GROUP BY
            `card`.`id`

Thanks in advance!!

Mariusz Sakowski · Accepted Answer · 2012-12-18 16:01:10Z

1

Use CONCAT function.

(...)
CASE `card`.`shared` WHEN 1 THEN CONCAT('http://mysite.com/webapplication/card/view?id=', `card`.`id`, '&shared') ELSE 'No URL' END 'URL',

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat

answered Dec 18, 2012 at 16:01

Mariusz Sakowski

3,28017 silver badges23 bronze badges

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

1 Comment

Developer Over a year ago

quick qn. can you pls tell me how to get all the time(for every record) url not just when it is 1..

Collectives™ on Stack Overflow

mysql generating dynamic url using id of the table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related