0

Is it possible and if so how to get only lets say 250 characters from a field with type "text" in my MySQL query? Or should I better create a new field with type varchar(250) which would contain the brief text for article?

Rihards
  • 10,241
  • 14
  • 58
  • 78

1 Answers1

2

You can use SUBSTRING Function in MySQL: For e.g. SELECT SUBSTRING('CYBERNATE', 2, 3) would return YBE

Chandu
  • 81,493
  • 19
  • 133
  • 134