Code: Select all
<a href="http://#web_address#">#web_address#</a>
What do I need to do?
Code: Select all
<a href="http://#web_address#">#web_address#</a>
Code: Select all
SELECT *, CONCAT( '<a href="http://', web_address, '">', web_address, '</a>) AS html_link FROM company