how to reduce result's data length?

AmirFar · #1 (**permalink**) 10-19-04, 13:32

I have some fields with longText datatype. Each record contain half a page of characters in just one field.

I need only the first n characters of each record's longText field, not all of it.

For example one field may contain 1500 characters. When I run a SELECT command I want database to send me only the first 100 characters of that field, not all of it.

How can I do so by SQL commands on a mysql server?

r937 · #2 (**permalink**) 10-19-04, 13:43

have you tried the LEFT() function?

Internet Services

Web Development

Digital Marketing

Consumer Tech