Suppose I have a MySQL table of one column: "Message". It is of type TEXT. I now want to query all rows, but the text can be large (not extremely large but large) and I only want to get a summary of them. For example the result can be populated into a list.

Is there a way to trim the text to a specific length (say, 10 characters), and add ellipsis if the text is trimmed?

For example:

Message
-----------
12345678901234
1234567890
12345
12345678901

Query result:

1234567...
1234567890
12345
1234567...

Thanks!

Edit
Report