LOWER Converts a string to lower-case
Note: The LCASE() function is equal to the LOWER() function.
SELECT LOWER("Vlr SQL Tutorialby VenkaT!");
------------------------------
LPAD Left-pads a string with another string, to a certain length
SELECT LPAD("SQL Tutorial", 12, "VLR ");
-----
LTRIM Removes leading spaces from a string
SELECT LTRIM(" SQL Tutorial") AS LeftTrimmedString;
----------
MID Extracts a substring from a string (starting at any position)
SELECT MID("VLR TRAINING", 5, 3) AS ExtractString;
The MID() and SUBSTR() functions equals the SUBSTRING() function.
----------------
name ramesh
POSITION Returns the position of the first occurrence of a substring in a string
SELECT POSITION("c" IN "vlrtrain.com") AS MatchPosition;
---------------
REPEAT Repeats a string as many times as specified
SELECT REPEAT("Vlr Training ", 7);
----------------
MariaDB [(none)]> use vlrinst;
Database changed
MariaDB [vlrinst]> select lower("Vlr trainin");
+----------------------+
| lower("Vlr trainin") |
+----------------------+
| vlr trainin |
+----------------------+
1 row in set (0.037 sec)
MariaDB [vlrinst]> select lpad("training and palcements",5 ," vlr");
+--------------------------------------------+
| lpad("training and palcements",5 ," vlr") |
+--------------------------------------------+
| train |
+--------------------------------------------+
1 row in set (0.002 sec)
MariaDB [vlrinst]> select lpad("training and palcements",13 ," vlr");
+---------------------------------------------+
| lpad("training and palcements",13 ," vlr") |
+---------------------------------------------+
| training and |
+---------------------------------------------+
1 row in set (0.001 sec)
MariaDB [vlrinst]> select lpad("training and palcements",13 ,"vlr");
+-------------------------------------------+
| lpad("training and palcements",13 ,"vlr") |
+-------------------------------------------+
| training and |
+-------------------------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select lpad("training and palcements",1 ,"vlr");
+------------------------------------------+
| lpad("training and palcements",1 ,"vlr") |
+------------------------------------------+
| t |
+------------------------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select ltrim(" vlr Training ");
+----------------------------+
| ltrim(" vlr Training ") |
+----------------------------+
| vlr Training |
+----------------------------+
1 row in set (0.046 sec)
MariaDB [vlrinst]> select CHAR_LENGTH(ltrim(" vlr Training "));
+-----------------------------------------+
| CHAR_LENGTH(ltrim(" vlr Training ")) |
+-----------------------------------------+
| 15 |
+-----------------------------------------+
1 row in set (0.001 sec)
MariaDB [vlrinst]> select char_length(" vlr training ");
+-----------------------------------+
| char_length(" vlr training ") |
+-----------------------------------+
| 18 |
+-----------------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select char_length(ltrim(" vlr training "));
+------------------------------------------+
| char_length(ltrim(" vlr training ")) |
+------------------------------------------+
| 15 |
+------------------------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select char_length(trim(" vlr training "));
+-----------------------------------------+
| char_length(trim(" vlr training ")) |
+-----------------------------------------+
| 12 |
+-----------------------------------------+
1 row in set (0.025 sec)
MariaDB [vlrinst]> select mid("vlr training",5,8);
+-------------------------+
| mid("vlr training",5,8) |
+-------------------------+
| training |
+-------------------------+
1 row in set (0.001 sec)
MariaDB [vlrinst]> select mid("vlr training",5,2);
+-------------------------+
| mid("vlr training",5,2) |
+-------------------------+
| tr |
+-------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select position("train" in "vlr Training");
+-------------------------------------+
| position("train" in "vlr Training") |
+-------------------------------------+
| 5 |
+-------------------------------------+
1 row in set (0.001 sec)
MariaDB [vlrinst]> select position("ing" in "vlr Training");
+-----------------------------------+
| position("ing" in "vlr Training") |
+-----------------------------------+
| 10 |
+-----------------------------------+
1 row in set (0.000 sec)
MariaDB [vlrinst]> select Repeat("vlr ",30);
+-------------------------------------------------------------------------------------------------------------------------
| Repeat("vlr ",30)
+-------------------------------------------------------------------------------------------------------------------------
| vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr vlr
+-------------------------------------------------------------------------------------------------------------------------
1 row in set (0.015 sec)
MariaDB [vlrinst]> select repeat(name,2) from emp;
+----------------+
| repeat(name,2) |
+----------------+
| venkatvenkat |
| praveenpraveen |
| mounikamounika |
| revathirevathi |
| anjianji |
| harikaharika |
| praveenpraveen |
| pandupandu |
| pandupandu |
+----------------+
9 rows in set (0.107 sec)
MariaDB [vlrinst]>
No comments:
Post a Comment
Note: only a member of this blog may post a comment.