MySQL Text Field

[dj4uk]

Is there anyway within a SQL query to only return the first 100 characters of a text field not the full field that could be much larger?

[OhLordy]

have a look here.
HTH
Rob

[dj4uk]

Where? - no link!

[Norman_Graham]

Here link:

http://www.php.net/manual/en/function.count-chars.php

Norman

[dj4uk]

Thanks but I wanted this done within a query. Got a solution tho' :

$query = "select (LEFT(FIELD_NAME_HERE,20)) from TABLE_NAME";

Thanks for your suggestion.

[Norman_Graham]

I just noticed you wanted an SQL query, not PHP - sorry for being so hasty.

Norman

[OhLordy]

Sorry forgot the link here it is
http://www.mysql.com/doc/en/String_functions.html

Again, sorry about that. However it is still a case of RTFM 😉
Rob