sql - How to truncate the text returned for a column in a MySQL query -


A MySQL database has a table on which I am running Simple Select Quality (for quick diagnosis / analysis - since I am).

Select LEFT

Full_name, 32), user from era

Where the user is a table with column ID, full_name and age

I tried the above description and this job. Anyone have to do this?

[edit]

Sorry, when I said that this is not a work, I mean my SQL is just "an alias for the column In the form of "full (full_name, 32)" and field value outputs - which can be up to 256 characters in this case.

< / Pre>

quote:

Blockquote>

For all types, the position of the first letter in the string from which the accent is to be removed , Considered it as 1 The expertise.


Comments