Varchar(5000) or text?

Question

MySQL

Mariadb
innodb
field will be selected both when getting a specific record (for example, where id = ...)
and when getting multiple records (for example, where created_at > ...)
indexes are not needed for this field.
The most common operations are select.
What to choose?

Answer 1

The text type is designed for large amounts of data, varchar for small ones. It would be logical to assume that the choice of text would be more correct.