带结果的mysql concat字符串[关闭]

I have a table like this

Name  Country State
John  US      California

I want to do a select statement with a concat so I get something like this

http:// getmehelp / US / John.txt

SELECT CONCAT ( 'http://getmehelp/', country , '/', name , '.txt') AS link;

select concat('http://getmehelp/', country, '/', name, '.txt')
from your_table

The query you are looking for should be this one:

SELECT concat('http://getmehelp/',Country,'/',Name,'.txt')
FROM table;