Mysql Length Function

The Tutorial already illustrate you an example to find the length of the String. Now this section of tutorial helps you to find the Length Function in Mysql. The Query length('Roseindia.net') is used to compute the length of characters in Roseindia.net under the fieldname Length of string.

length(Roseindia.net) : The Query given below is used to compute the length of string enclosed in single quotes under the specified column name.

Query:

mysql> select length('Roseindia.net')as Lengthofstring;

Output:-

+----------------+
| Lengthofstring |
+----------------+
|             13 |
+----------------+
1 row in set (0.00 sec)

Related Tags for Mysql Length Function:
.net,  sql,  mysql,  c,  string,  query,  com,  function,  fun,  io,  help,  sed,  find,  char,  tutorial,  field,  read,  name,  ria,  this,  length,  character,  characters,  ie,  example,  unc,  cte,  to,  exam,  ld,  e,  il,  section,  put,  use,  in,  no,  m,  ps,  tr,  net,  os,  net,  os,  ad,  func,  compute,  me,  rate,  tor,  xa,  xamp,  s,  at,  rac,  my,  is,  ha,  ll,  mpl,  dia,  dn,  ea,  ar,  act,  str,  tutor,  s,  s,  ri,  ring,  th,  st,  dna,  fin,  ple,  pl,  nd,  on,  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 Length Function  

Post your Comment

Your Name (*) :

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