KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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!
Tags (comma-separated)
Save Edits
Cancel