Mysql MidString

Mysql MidString is used to return the string, with sub string beginning at position pos and len.

Mysql MidString

Mysql MidString

     

Mysql MidString is used to return the string, with sub string beginning at position pos and len.This is a synonym for SUB STRING( str , pos , len ) . 

SYNTAX:-MID(str,pos,len)

Understand with Example

The Tutorial illustrate an example from 'Mysql MidSTRING'.To understand this example we use the given below syntax that return the string begins with position 1 and length 9.

Query:-

 

 

mysql> select mid('Roseindia.net',1,9)as MIDSTRING;

Output:- 

+-----------+
| MIDSTRING |
+-----------+
| Roseindia |
+-----------+
1 row in set (0.00 sec)

Tutorials

  1. PHP SQL Timestamp
  2. MySQL Append Column
  3. Mysql where
  4. Mysql Update
  5. Mysql Now Current DateTime
  6. Mysql Multiply
  7. Mysql Multiplication Columns
  8. Mysql Multiple Date Insert
  9. Mysql Mod Function
  10. Mysql Minus
  11. Mysql Minimum Query
  12. Mysql MidString
  13. Mysql Merge Statement
  14. Mysql Max Date
  15. Mysql Math Function
  16. Mysql Ltrim
  17. Mysql Lpad
  18. Mysql Lpad Function
  19. Mysql Lower Case
  20. Mysql Looping
  21. Mysql Loop in Procedure
  22. Mysql Loader Examples
  23. Mysql Loader Tutorial
  24. Mysql Loader Control File
  25. Mysql List Tables
  26. Mysql List
  27. Mysql Limit
  28. Mysql like syntax
  29. Mysql Like Operator
  30. Mysql Like Command
  31. Mysql Like Operator
  32. Mysql Length Function
  33. Mysql String Length
  34. Mysql Left Function
  35. Mysql Left
  36. Mysql Last Record
  37. Mysql last day of month
  38. Mysql Last
  39. Mysql Difference
  40. MySQL Addition