How to implement search by tag search type in twitter?

Question

Database

How does twitter tag search roughly work, at the database level? Perhaps I do not know sql very well, but I do not know how to add an arbitrary number of tags to a record in the table, because the number of columns is limited.

Answer 1

In PostgreSQL, for example, you can create a field of type array of strings and add an arbitrary number of tags there.