Can mysql extract two fields to combine?

Question

It is necessary to extract the contents of two fields in mysql, one is the keyword, and the other is the link corresponding to the keyword
Is there any way to extract and combine them?
Duplication also needs to be removed, because the keywords in mysql are duplicated with the corresponding links

< /p>

Achieve the following effects

<a href="Link corresponding to the keyword">Keyword</>

Answer 1

You need to use mysql's concat function and deduplication function distinct. Refer to the sql statement below!

select distinct concat('<a href="',`description`,'">',`title`,'</a>') as rs from `xxx`

Answer 2

Direct

SELECT DISTINCT `title`, `description` FROM `xxx`

That’s it