Re: function in mysql

[Jonathan Stephens]

Hi Sergey,

The MySQL QUOTE() function does *not* add quotes; it *escapes the string*. This is not at all the same thing.

TRIM() does *not* add spaces; it *removes* leading and trailing spaces.

Please see this table of MySQL 5.6 string functions and operators; it lists all of the string functions and operators supported by MySQL 5.6 with a brief description of each, and provides a link from the name of each function/operator to its complete description in the Manual. This should provide you with the info you're looking for.

cheers,

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle