mysql calculation function details

SELECT CONCAT(vend_name,'(',vend_country,')') as info
from vendors
ORDER BY vend_name

Left() Returns the characters on the left side of a string Length() Returns the length of a string Locate() Finds a substring of a string Lower() Converts a string to lowercase LTrim() Removes spaces on the left side of a string Right() Returns the characters on the right side of a string RTrim() Removes spaces on the right side of a string Soundex() Returns the SOUNDEX value of a string SubString() Returns the characters of a substring Upper() Converts a string to uppercase

AddDate() adds a date (day, week, etc.)
AddTime() adds a time (hour, minute, etc.)
CurDate() Returns the current dateCurTime() Returns the current timeDate() Returns the date portion of a date and timeDateDiff() Calculates the difference between two datesDate_Add() Highly flexible date operation functionDate_Format() Returns a formatted date or time stringDay() Returns the day portion of a dateDayOfWeek() Returns the corresponding day of the week for a dateHour() Returns the hour portion of a timeMinute() Returns the minute portion of a timeMonth() Returns the month portion of a dateNow() Returns the current date and timeSecond() Returns the seconds portion of a timeTime() Returns the hour portion of a date and timeYear() Returns the year portion of a date

Abs() Returns the absolute value of a numberCos() Returns the cosine of an angleExp() Returns the exponential value of a numberMod() Returns the remainder of a division operationPi() Returns the ratio of piRand() Returns a random numberSin() Returns the sine of an angleSqrt() Returns the square root of a numberTan() Returns the tangent of an angle