# Save text with links in a SQL database

I’d like to create Post functionality similar to Facebook. I’d like users to be able to mention others and for the mention to hyperlink to a users page.

What is the best way to save this text? The approach that I’m thinking is to save the text along with the hyperlink in a text field in PostgreSQL.

"Thanks <a href="/johnny">Johnny</a>"


However, this approach lacks structure. For example, there is no database entry relating johnny to mentions.

What’s the best way to save this data?

Source: AngularJS