Mysql String Length

Mysql Length is used to return the length of the String.

Understand with Example

The Tutorial illustrate an example from 'Mysql String Length'.To grasp this example we use Length ( ) query that returns the length size of string.

Length('Girish')as  StrLength: The Syntax is used to return the length size of string 'Girish' as fieldname StrLength.  

Query:

mysql> Select Length('Girish')as StrLength;

Output:-

+-----------+
| StrLength |
+-----------+
|         6 |
+-----------+
1 row in set (0.00 sec)

Related Tags for Mysql String Length:
sql,  mysql,  string,  query,  asp,  size,  tutorial,  return,  ria,  this,  length,  example,  to,  exam,  e,  il,  use,  from,  in,  as,  m,  tr,  rate,  tor,  xa,  xamp,  s,  urn,  sp,  at,  ras,  my,  is,  ha,  ll,  mpl,  str,  tutor,  z,  s,  s,  ri,  ring,  th,  st,  hat,  grasp,  ple,  pl,  om,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: Mysql String Length  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):