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,081
  • 14
  • 55
  • 77

1 Answers1

2

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

Chandu
  • 78,650
  • 19
  • 129
  • 131