José Carlos Santos wrote:[url]http://dev.mysql.com/doc/refman/5.0/en/string-functions.html[/url]> Suppose that I have a table with fields which can be rather long string
> of characters. For instance, it can be a table called library concerning
> the books from a library and the fields might be the title and the
> author of the books. If I type
>
> SELECT title, author FROM library;
>
> this might be hard to read on screen. Is it possible to display, say,
> only the first 20 characters of each field?
<snip>
LEFT(str,len)
Returns the leftmost len characters from the string str.
mysql> SELECT LEFT('foobarbar', 5);
-> 'fooba'
</snip>
Greetings
Kai
--
This signature is left as an exercise for the reader.
Bookmarks