How does CNC work?

Question

URL Handling

Please explain on your fingers. Thanks in advance.
For example, there is a route:

/post/{id} - where id = post_id (everything is clear here)

But if there is such a route:

/post/how to%20tame%20a dragon

In this case, what are we doing a query to the database to pull out information?
Looking for a post on "how to%20tame%20a dragon"??? OO

Answer 1

a separate field (table) with links and their correspondences is usually used - a post is selected from the table according to this text. In especially uporotymi variants, you can do a search by title (title) with reduction to lowercase.