strleft

Description

Syntax

‘VARCHAR STRAIGHT (VARCHAR STR)’

It returns the left part of a string of specified length

example

  1. mysql> select strleft("Hello doris",5);
  2. +------------------------+
  3. (Hello doris', 5)'1244;
  4. +------------------------+
  5. | Hello |
  6. +------------------------+

keyword STRLEFT