{"id":5355,"date":"2022-01-17T07:00:00","date_gmt":"2022-01-17T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=5355"},"modified":"2022-09-21T17:07:16","modified_gmt":"2022-09-21T11:37:16","slug":"mysql-string-function","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-string-function\/","title":{"rendered":"MySQL String Function"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"MySQL-String-Function\">MySQL String Function<\/h2>\n\n\n\n<p>MySQL \u092f\u093e \u0915\u093f\u0938\u0940 \u092d\u0940 SQL \u092e\u0947 String Manipulation \u0915\u0947 \u0932\u093f\u090f \u0915\u0941\u091b Predefined Function \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u094d\u0939\u0947 MySQL String Function \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948 \u0964 \u0906\u0907\u090f \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e MySQL String Function \u0915\u094c\u0928 &#8211; \u0915\u094c\u0928 \u0938\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948 \u0909\u0928\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 MySQL String Function With Example \u0938\u092e\u091d\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p> <\/p>\n\n\n\n<p>\u0938\u092d\u0940 String Function \u0915\u094b \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u090f\u0915 Example Table \u0932\u0940 \u0939\u0948\u0902 \u0913\u0930 \u0909\u0938\u092e\u0947 \u0915\u0941\u091b Dummy Data Enter \u0915\u093f\u090f \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0906\u092a\u0915\u094b \u090f\u0915 \u090f\u0915 function \u0915\u094b \u0938\u092e\u091d\u093e \u0938\u0915\u0947 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"115\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-30.png?resize=427%2C115&#038;ssl=1\" alt=\"MySQL String Function Example\" class=\"wp-image-6252\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-30.png?w=427&amp;ssl=1 427w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-30.png?resize=300%2C81&amp;ssl=1 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Table \u092e\u0947 \u0939\u092e\u0928\u0947 Student Name, Father Name, Mother Name \u0914\u0930 Surname \u0915\u0947 Column \u0932\u093f\u090f \u0939\u0948\u0902 \u0964     <\/p>\n\n\n\n<p>\u0906\u0907\u090f \u0905\u092c \u0939\u092e \u090f\u0915 \u090f\u0915 \u0915\u0930 \u0938\u092d\u0940 Function \u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u094b \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"LENGTH\">MySQL <strong>LENGTH(String) <\/strong><\/h2>\n\n\n\n<p>String \u0915\u0940 Length \u092f\u093e\u0928\u093f \u0915\u0940 Character Count \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, length(stud_nm) as stud_length \nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"182\" height=\"106\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-31.png?resize=182%2C106&#038;ssl=1\" alt=\"MySQL String Function - LENGTH\" class=\"wp-image-6253\"\/><\/figure>\n\n\n\n<p>MySQL Length Function \u0938\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 String \u092e\u0947 \u0915\u093f\u0924\u0928\u0947 Character \u0939\u0948\u0902 \u0909\u0928\u0915\u0947 Count \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0906\u092a \u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 ankit 5 character \u0915\u093e \u0939\u0948\u0902 \u0913\u0930 \u0930\u093e\u0939\u0941\u0932 \u092d\u0940 5 \u0907\u0938\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 String \u0915\u0940 Length Find \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0927\u094d\u092f\u093e\u0928 \u0930\u0939\u0947 \u092f\u0926\u093f \u0939\u092e String \u0915\u0947 \u092a\u0939\u0932\u0947 , \u092c\u0940\u091a \u092e\u0947 \u0914\u0930 \u0906\u0916\u0930\u0940 \u092e\u0947 \u0915\u094b\u0908 space \u092d\u0940 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u092d\u0940 \u090f\u0915 Character Count \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"CONCAT\"><strong>CONCAT( <strong>String1,  <strong>String2, ..  <strong>StringN <\/strong><\/strong><\/strong> )<\/strong><\/h2>\n\n\n\n<p>\u0926\u094b \u092f\u093e  \u0926\u094b \u0938\u0947 \u0905\u0927\u093f\u0915 String \u0915\u094b \u091c\u094b\u095c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Concat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939\u093e\u0901 \u092a\u0930 \u091c\u094b\u095c\u0928\u0947 \u0938\u0947 \u0905\u092d\u093f\u092a\u094d\u0930\u093e\u092f \u0939\u0948\u0902 \u0915\u0940 \u090f\u0915 String \u0915\u0947 \u092c\u093e\u0926 \u092e\u0947 \u0926\u0942\u0938\u0930\u0940 String \u0915\u094b \u091c\u094b\u095c\u0928\u093e \u0906\u0907\u090f Example \u0938\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, father_nm, stud_surname, \nconcat(stud_nm ,' ', father_nm, ' ', stud_surname) as full_nm\nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"110\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-33.png?resize=460%2C110&#038;ssl=1\" alt=\"MySQL String Function - CONCAT\" class=\"wp-image-6255\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-33.png?w=460&amp;ssl=1 460w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-33.png?resize=300%2C72&amp;ssl=1 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/figure>\n\n\n\n<p>\u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a\u0928\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 Student Name , Father Name \u0914\u0930 Surname \u0915\u094b \u091c\u094b\u095c \u0915\u0930 \u090f\u0915 Full Name String \u092c\u0928\u093e\u0908 \u0939\u0948\u0902  \u0964 \u0906\u092a\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u093e \u0915\u0940 \u090f\u0915 String \u0938\u0947 \u0926\u0942\u0938\u0930\u0940 String \u0915\u0947 \u092c\u0940\u091a Gap \u0930\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947 Space \u092d\u0940 \u0939\u0930 \u090f\u0915 \u0915\u0947 \u092c\u0940\u091a Concat \u0915\u0940 \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u092c\u093e\u0930 \u092c\u093e\u0930 Space \u0915\u094b \u092d\u0940 \u0910\u0921 \u0928 \u0915\u0930\u0947 \u0924\u094b \u0906\u092a  <strong>CONCAT_WS<\/strong>  SQL String Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>CONCAT_WS(Separator,  String1,  <strong>String2, ..  <strong>StringN <\/strong><\/strong>) <\/strong><\/h2>\n\n\n\n<p>\u0926\u094b \u092f\u093e \u0926\u094b \u0938\u0947 \u0905\u0927\u093f\u0915 String \u0915\u094b Separator \u0915\u0947 \u0938\u093e\u0925 \u091c\u094b\u095c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e concat_ws \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, father_nm, stud_surname, \nconcat_ws(' ', stud_nm , father_nm,  stud_surname) as full_nm\nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"459\" height=\"109\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-34.png?resize=459%2C109&#038;ssl=1\" alt=\"MySQL String Function - CONCAT_WS\" class=\"wp-image-6257\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-34.png?w=459&amp;ssl=1 459w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-34.png?resize=300%2C71&amp;ssl=1 300w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/><\/figure>\n\n\n\n<p>\u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a\u0928\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 Concat_ws \u092e\u0947 \u0939\u092e\u0947 \u0939\u0930 String \u0915\u0947 \u092c\u0940\u091a \u092e\u0947 Space \u0910\u0921 \u0915\u0930\u0928\u093e \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u0940 \u0939\u0948 \u0915\u0947\u0935\u0932 \u090f\u0915 \u092c\u093e\u0930 \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 Argument \u092e\u0947 \u0939\u092e Space \u092f\u093e \u091c\u094b \u092d\u0940 Character \u092f\u093e Sting \u0906\u092a Separate \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 , \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"TRIM\">TRIM (String) <\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u0935\u0939\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0913\u0930 \u092c\u093e\u0926 \u0915\u0940 Space \u0915\u094b Remove \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Trim \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948 \u0964<\/p>\n\n\n\n<p>Trim \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0939\u092e \u0905\u092a\u0928\u0940 Table \u0915\u0947 Data \u092e\u0947 \u0915\u0941\u091b Changes \u0915\u0930 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902, \u091f\u0947\u092c\u0932 \u092e\u0947 \u0939\u092e\u0928\u0947 Student Name \u092e\u0947 Enter Data \u0915\u0947 \u092a\u0939\u0932\u0947 \u0914\u0930 \u092c\u093e\u0926 \u092e\u0947 \u0915\u0941\u091b Space \u0926\u0940 \u0939\u0948\u0902 , \u091c\u0940\u0938\u0947 \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u090f\u0915 SQL Execute \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, length(stud_nm), concat(\"'\", stud_nm, \"'\") \nFROM `studmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"106\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-56.png?resize=371%2C106&#038;ssl=1\" alt=\"MySQL String Function Trim\" class=\"wp-image-6298\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-56.png?w=371&amp;ssl=1 371w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-56.png?resize=300%2C86&amp;ssl=1 300w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 SQL \u092e\u0947 \u0939\u092e\u0928\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 concat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0939\u092e\u0928\u0947 Student Name \u0915\u0947 \u092a\u0939\u0932\u0947 \u0914\u0930 \u092c\u093e\u0926 \u092e\u0947 Inverted Comma \u0932\u0917\u093e \u0926\u093f\u090f \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 \u0939\u092e Space \u0915\u094b Output \u092e\u0947 \u0926\u0947\u0916 \u0938\u0915\u0947\u0964 <\/p>\n\n\n\n<p>\u0905\u092c \u0939\u092e Trim Function \u0915\u094b Run \u0915\u0930 \u0926\u0947\u0916\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 Result \u0915\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, trim(stud_nm), concat(\"'\", trim(stud_nm), \"'\") \nFROM `studmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"395\" height=\"110\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-57.png?resize=395%2C110&#038;ssl=1\" alt=\"MySQL String Function Trim\" class=\"wp-image-6299\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-57.png?w=395&amp;ssl=1 395w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-57.png?resize=300%2C84&amp;ssl=1 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/><\/figure>\n\n\n\n<p>\u0926\u0947\u0916\u093f\u090f \u091c\u092c \u0939\u092e\u0928\u0947 Trim \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0924\u094b String \u0915\u0947 \u092a\u0939\u0932\u0947 \u0914\u0930 \u092c\u093e\u0926 \u0915\u0940 Space Remove \u0939\u094b \u0917\u0908 , \u0927\u094d\u092f\u093e\u0928 \u0930\u0939\u0947 \u092f\u0939 String \u0915\u0947 \u092a\u0939\u0932\u0947 \u0914\u0930 \u092c\u093e\u0926 \u0915\u0940 Space \u0939\u0940 Remove \u0915\u0930 \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u092c\u0940\u091a \u0915\u0940 Space \u0906\u092a Trim \u0938\u0947 Remove \u0928\u0939\u0940\u0902 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>LTRIM(String) <\/strong><\/h2>\n\n\n\n<p>String \u0915\u0947 Left Side \u0915\u0940 Space \u0915\u094b Trim \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Ltrim \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u0938\u0947 \u0915\u0947\u0935\u0932 Left Side \u092f\u093e\u0928\u093f \u0915\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0915\u0940 Space Remove \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, ltrim(stud_nm), concat(\"'\", ltrim(stud_nm), \"'\") \nFROM `studmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"401\" height=\"111\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-58.png?resize=401%2C111&#038;ssl=1\" alt=\"MySQL String Function - LTRIM\" class=\"wp-image-6300\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-58.png?w=401&amp;ssl=1 401w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-58.png?resize=300%2C83&amp;ssl=1 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>RTRIM(String)<\/strong><\/h2>\n\n\n\n<p>String \u0915\u0947 Right Side \u0915\u0940 Space \u0915\u094b Trim \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f RTrim \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938\u0938\u0947 \u0915\u0947\u0935\u0932 Right Side \u0915\u0940 Space Remove \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964    <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sass\" class=\"language-sass\">SELECT stud_nm, rtrim(stud_nm), concat(\"'\", rtrim(stud_nm), \"'\") \nFROM `studmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"401\" height=\"107\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-59.png?resize=401%2C107&#038;ssl=1\" alt=\"MySQL String Function - RTRIM\" class=\"wp-image-6301\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-59.png?w=401&amp;ssl=1 401w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-59.png?resize=300%2C80&amp;ssl=1 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"CASE\">CHANGE CASE FUNCTION<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 String \u0915\u0947 Case change \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e Upper Case \u0938\u0947 Lower Case \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e Lower Case \u0938\u0947 Upper Case \u092e\u0947 change \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0906\u092a \u0907\u0928 Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><br><strong>UPPER() : <\/strong>String \u0915\u0947 \u0938\u092d\u0940 Character \u0915\u094b Upper Case \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <br><strong>UCASE() :<\/strong> String \u0915\u0947 \u0938\u092d\u0940 Character \u0915\u094b Upper Case \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964  <br><strong>LOWER() :<\/strong> String \u0915\u0947 \u0938\u092d\u0940 Character \u0915\u094b Lower Case \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964  <br><strong>LCASE()  :<\/strong> String \u0915\u0947 \u0938\u092d\u0940 Character \u0915\u094b Lower Case \u092e\u0947 \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964   <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nupper(stud_nm) as s_upper, ucase(stud_nm) as s_ucase, \nlower(stud_nm) as s_lower, lcase(stud_nm) as s_lcase \nFROM `studmst` WHERE 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"434\" height=\"113\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-32.png?resize=434%2C113&#038;ssl=1\" alt=\"MySQL String Function - Upper Case Lower Case\" class=\"wp-image-6254\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-32.png?w=434&amp;ssl=1 434w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-32.png?resize=300%2C78&amp;ssl=1 300w\" sizes=\"auto, (max-width: 434px) 100vw, 434px\" \/><\/figure>\n\n\n\n<p>\u092f\u0939 \u0939\u092e\u0928\u0947 \u090f\u0915 \u0938\u093e\u0925 \u0939\u0940 upper, lower, ucase, lcase \u0915\u093e Execute \u0915\u0930 \u0926\u0947\u0916\u093e \u0907\u0938\u092e\u0947 Upper \u0914\u0930 ucase \u090f\u0915 \u091c\u0948\u0938\u0947 \u0939\u0948\u0902 \u0913\u0930 Lower \u0914\u0930 Lcase \u092d\u0940 \u090f\u0915 \u091c\u0948\u0938\u0947 \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"LEFT\"><strong>LEFT(String, No of Character)<\/strong><\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u092e\u0947 Left Side \u0938\u0947 String Get \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Left \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nleft(stud_nm, 3) as stud_3, \nleft(stud_nm, 2) as stud_2\nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"201\" height=\"102\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-38.png?resize=201%2C102&#038;ssl=1\" alt=\"MySQL String Function - LEFT\" class=\"wp-image-6266\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>RIGHT<strong>(String, No of Character)<\/strong> <\/strong><\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u092e\u0947 Right Side \u0938\u0947 String Get \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Right \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, right(stud_nm, 3) as stud_3, right(stud_nm, 2) as stud_2\nFROM `studmst` WHERE 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"203\" height=\"108\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-39.png?resize=203%2C108&#038;ssl=1\" alt=\"MySQL String Function - RIGHT\" class=\"wp-image-6267\"\/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"SUBSTR\"><strong>SUBSTR(String, Start, No of Character) <\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 \u0915\u093f\u0938\u0940 Position \u0938\u0947 String \u092f\u093e Character \u0915\u094b get \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e substr \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nsubstr(stud_nm, 1,3) as stud_1_to_3, \nsubstr(stud_nm, 2,3) as stud_2_to_3, \nsubstr(stud_nm, 1,1) as stud_1_to_1\nFROM studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"114\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-35.png?resize=371%2C114&#038;ssl=1\" alt=\"MySQL String Function - SUBSTR\" class=\"wp-image-6260\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-35.png?w=371&amp;ssl=1 371w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-35.png?resize=300%2C92&amp;ssl=1 300w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 Student Name \u0915\u0947 First Three Character, \u0926\u0942\u0938\u0930\u0947 Character \u0938\u0947 Tree Character , \u0914\u0930 \u0915\u0947\u0935\u0932 \u092a\u0939\u0932\u093e Character substr \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 find \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>SUBSTRING( <strong>String, Start, No of Character<\/strong> ) <\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 \u0915\u093f\u0938\u0940 Position \u0938\u0947 String \u0915\u094b get \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Substring \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 \u092d\u0940 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 Substr \u091c\u0948\u0938\u093e \u0939\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nSUBSTRING(stud_nm, 1,3) as stud_1_to_3, \nSUBSTRING(stud_nm, 2,3) as stud_2_to_3, \nSUBSTRING(stud_nm, 1,1) as stud_1_to_1\nFROM `studmst` WHERE 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"372\" height=\"110\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-36.png?resize=372%2C110&#038;ssl=1\" alt=\"MySQL String Function - SUBSTRING\" class=\"wp-image-6262\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-36.png?w=372&amp;ssl=1 372w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-36.png?resize=300%2C89&amp;ssl=1 300w\" sizes=\"auto, (max-width: 372px) 100vw, 372px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 Student Name \u0915\u0947 First Three Character, \u0926\u0942\u0938\u0930\u0947 Character \u0938\u0947 Tree Character , \u0914\u0930 \u0915\u0947\u0935\u0932 \u092a\u0939\u0932\u093e Character substring \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 find \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MID( <strong>String, Start, No of Character<\/strong> ) <\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 \u0915\u093f\u0938\u0940 Position \u0938\u0947 String \u0915\u094b get \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e mid \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u092f\u0939 \u092d\u0940 Substr \u0913\u0930 Substring \u091c\u0948\u0938\u0947 \u0939\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, mid(stud_nm, 1,3) as stud_1_to_3, mid(stud_nm, 2,3) as stud_2_to_3, mid(stud_nm, 1,1) as stud_1_to_1\nFROM `studmst` WHERE 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"107\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-37.png?resize=367%2C107&#038;ssl=1\" alt=\"MySQL String Function - MID\" class=\"wp-image-6264\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-37.png?w=367&amp;ssl=1 367w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-37.png?resize=300%2C87&amp;ssl=1 300w\" sizes=\"auto, (max-width: 367px) 100vw, 367px\" \/><\/figure>\n\n\n\n<p> \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 Student Name \u0915\u0947 First Three Character, \u0926\u0942\u0938\u0930\u0947 Character \u0938\u0947 Tree Character , \u0914\u0930 \u0915\u0947\u0935\u0932 \u092a\u0939\u0932\u093e Character mid \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 find \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964    <\/p>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u0907\u0938\u0915\u0947 \u092a\u0939\u0932\u0947 Left \u0926\u0947\u0916\u093e \u091c\u094b \u0915\u0947\u0935\u0932 Left side \u0938\u0947 \u0939\u0940 String Get \u0915\u0930\u0924\u093e \u0939\u0948\u0902 , \u092b\u093f\u0930 Right \u0926\u0947\u0916\u093e \u091c\u094b \u0915\u0940 Right Side \u0938\u0947 \u0939\u0940 String Get \u0915\u0930\u0924\u093e \u0939\u0948\u0902 , \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0928\u0947 substr , substring , \u0914\u0930 mid \u0926\u0947\u0916\u093e \u091c\u094b \u0915\u0940 \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u0940 \u0917\u0908 Position \u0938\u0947 \u0932\u0947\u0915\u0930 \u091c\u0940\u0924\u0928\u0947 Number of Character \u0926\u093f\u090f \u0939\u0948\u0902 \u0935\u0939\u093e\u0901 \u0924\u0915 \u0915\u0940 value \u0915\u094b Get \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"LOCATE\"><strong>LOCATE(Search String, String ) <\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 \u0915\u093f\u0938\u0940 String \u0915\u0940 Position \u0915\u094b \u092a\u0924\u093e \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Locate \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nlocate('a', stud_nm) as locate_a_pos, \nlocate('r', stud_nm) as locate_r_pos, \nlocate('n', stud_nm) as locate_n_pos\nFROM `studmst` WHERE 1<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"383\" height=\"114\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-40.png?resize=383%2C114&#038;ssl=1\" alt=\"MySQL String Function - LOCATE\" class=\"wp-image-6269\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-40.png?w=383&amp;ssl=1 383w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-40.png?resize=300%2C89&amp;ssl=1 300w\" sizes=\"auto, (max-width: 383px) 100vw, 383px\" \/><\/figure>\n\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 a \u0915\u0940 Position Find \u0915\u0940 \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u0905\u0902\u0915\u093f\u0924 \u092e\u0947 first \u092a\u0930 \u0939\u0948\u0902, \u0930\u093e\u0939\u0941\u0932 \u092e\u0947 second \u092a\u0930 \u0939\u0948\u0902 \u0914\u0930 \u0930\u093e\u092e\u0947\u0936\u094d\u0935\u0930 \u092e\u0947 \u092d\u0940 Second Position \u092a\u0930 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e-\u0930-\u0905\u0928-\u092f-\u0906\u0930-\u091f-\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>\u00a0<\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>POSITION( <strong>Search String, String<\/strong> ) <\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 \u0915\u093f\u0938\u0940 String \u0915\u0940 Position \u0915\u094b \u092a\u0924\u093e \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Position \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964  \u092f\u0939 \u092d\u0940 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 Locate \u091c\u0948\u0938\u0947 \u0939\u0940 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, \nposition('a' in stud_nm) as pos_a, \nposition('r' in stud_nm) as pos_r, \nposition('n' in  stud_nm) as pos_n\nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"251\" height=\"107\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-41.png?resize=251%2C107&#038;ssl=1\" alt=\"MySQL String Function - POSITION\" class=\"wp-image-6270\"\/><\/figure>\n\n\n\n<p> \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 a \u0915\u0940 Position Find \u0915\u0940 \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u0905\u0902\u0915\u093f\u0924 \u092e\u0947 first \u092a\u0930 \u0939\u0948\u0902, \u0930\u093e\u0939\u0941\u0932 \u092e\u0947 second \u092a\u0930 \u0939\u0948\u0902 \u0914\u0930 \u0930\u093e\u092e\u0947\u0936\u094d\u0935\u0930 \u092e\u0947 \u092d\u0940 Second Position \u092a\u0930 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"LPAD\"><strong>LPAD(String, No of Character, Add String)<\/strong><\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 Left \u092e\u0947 Space \u0926\u0947\u0928\u0947 \u092f\u093e \u0915\u094b\u0908 Any Character \/ String \u091c\u094b \u091c\u094b\u0921\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e LPAD \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, length(stud_nm) as len, LPAD(stud_nm, 10, \"0\") \nfrom  studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"284\" height=\"118\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-53.png?resize=284%2C118&#038;ssl=1\" alt=\"MySQL String Function - LPAD\" class=\"wp-image-6294\"\/><\/figure>\n\n\n\n<p>\u0906\u092a\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u093e \u0939\u094b\u0917\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 LPAD \u092e\u0947 10 \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u0938\u0947 \u091c\u094b \u092d\u0940 String \u092c\u0928 \u0915\u0930 \u0906\u090f\u0917\u0940 \u0909\u0938\u0915\u0940 Width 10 \u0939\u094b\u0917\u0940 \u0914\u0930 \u091c\u0939\u093e\u0902 \u092a\u0930 \u0915\u092e Character \u0939\u094b\u0902\u0917\u0947 \u0935\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u093f\u090f \u0917\u090f Character \/ String Add \u0939\u094b \u091c\u093e\u090f\u0902\u0917\u0947\u0964 LPAD \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u093f\u090f \u0917\u090f 0 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 \u092a\u0939\u0932\u0947 \u0910\u0921 \u0939\u094b \u0915\u0930 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong>RPAD(String, No of Character, Add String)<\/strong> <\/strong><\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 Right \u092e\u0947 Space   \u0926\u0947\u0928\u0947 \u092f\u093e \u0915\u094b\u0908 Any Character \/ String \u091c\u094b \u091c\u094b\u0921\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e RPAD \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, length(stud_nm) as len, RPAD(stud_nm, 10, \"0\") \nfrom  studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"111\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-54.png?resize=281%2C111&#038;ssl=1\" alt=\"MySQL String Function - RPAD\" class=\"wp-image-6295\"\/><\/figure>\n\n\n\n<p>\u0906\u092a\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u093e \u0939\u094b\u0917\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 RPAD \u092e\u0947 10 \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u0938\u0947 \u091c\u094b \u092d\u0940 String \u092c\u0928 \u0915\u0930 \u0906\u090f\u0917\u0940 \u0909\u0938\u0915\u0940 Width 10 \u0939\u094b\u0917\u0940 \u0914\u0930 \u091c\u0939\u093e\u0902 \u092a\u0930 \u0915\u092e Character \u0939\u094b\u0902\u0917\u0947 \u0935\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u093f\u090f \u0917\u090f Character \/ String Add \u0939\u094b \u091c\u093e\u090f\u0902\u0917\u0947\u0964 RPAD \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u093f\u090f \u0917\u090f 0 \u0938\u094d\u091f\u094d\u0930\u093f\u0902\u0917 \u0915\u0947 \u092c\u093e\u0926 \u092e\u0947  \u0910\u0921 \u0939\u094b \u0915\u0930 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u0947 \u0939\u0948 \u0964  <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"SPACE\"><strong>SPACE(No of Spaces) <\/strong><\/h2>\n\n\n\n<p>\u0926\u093f\u092f\u0947  \u0917\u090f \u0928\u0902\u092c\u0930 \u091c\u0940\u0924\u0928\u0947 Space \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Space \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT concat('a' , space(10) , 'b')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"50\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-44.png?resize=190%2C50&#038;ssl=1\" alt=\"MySQL String Function - SPACE\" class=\"wp-image-6278\"\/><\/figure>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 a \u0914\u0930 b \u0915\u0947 \u092c\u0940\u091a \u092e\u0947 space \u0915\u094b concat \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 \u0906\u092a\u0915\u094b Result \u092e\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u0940 \u0939\u094b\u0917\u0940 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"REPEAT\"><strong>REPEAT(String , Repeat Times )<\/strong><\/h2>\n\n\n\n<p>String \u0915\u094b \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u092c\u093e\u0930 \u092a\u0941\u0928\u0930\u093e\u0935\u0924\u094d\u0924\u093f (Repeat) \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e repeat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u091c\u0948\u0938\u0947 \u0915\u0940 \u0939\u092e\u0928\u0947 Space \u092e\u0947 \u0915\u0947\u0935\u0932 \u0926\u093f\u090f \u0917\u090f number \u0924\u0915 space \u092c\u0928\u093e\u0908 \u0925\u0940 \u0907\u0938 \u092e\u0947 \u0939\u092e \u0915\u093f\u0938\u0940 \u092d\u0940 character \/ String \u0915\u094b Repeat \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT REPEAT('a',10)<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"124\" height=\"42\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-45.png?resize=124%2C42&#038;ssl=1\" alt=\"MySQL String Function - REPEAT\" class=\"wp-image-6280\"\/><\/figure>\n\n\n\n<p>\u0907\u0938 Example \u092e\u0947 \u0939\u092e\u0928\u0947 a \u0915\u094b 10 \u092c\u093e\u0930 \u092a\u094d\u0930\u093f\u0928\u094d\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"REPLACE\"><strong>REPLACE(String, Replace From, Replace With )<\/strong><\/h2>\n\n\n\n<p>String \u092e\u0947 \u0938\u0947 particular \u0915\u093f\u0938\u0940 Word \u0915\u094b Replace \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e replace \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT REPLACE(stud_nm, \"a\", \"aaaaa\") from studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"229\" height=\"77\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-46.png?resize=229%2C77&#038;ssl=1\" alt=\"MySQLREPLACE FUNCTION\" class=\"wp-image-6282\"\/><\/figure>\n\n\n\n<p>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0928\u0947 a \u0915\u094b aaaaa \u0938\u0947 Replace \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u0939\u093e \u092a\u0930 \u092d\u0940 a \u092e\u093f\u0932\u0947\u0917\u093e \u092f\u0939 \u0909\u0938\u0947 aaaaa \u0938\u0947 replace \u0915\u0930 \u0926\u0947\u0917\u093e \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"REVERSE\"><strong>REVERSE(String) <\/strong><\/h2>\n\n\n\n<p>String \u0915\u0947 Character \u0915\u094b Reverse \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u094b Character \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0938\u092c\u0938\u0947 \u0906\u0916\u0930\u0940 \u092e\u0947 \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, REVERSE(stud_nm) from studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"224\" height=\"109\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-50.png?resize=224%2C109&#038;ssl=1\" alt=\"MySQL REVERSE FUNCTION\" class=\"wp-image-6289\"\/><\/figure>\n\n\n\n<p>\u091c\u093e\u0907\u092f\u093e \u0915\u0940 \u0906\u092a\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0926\u0947\u0916\u093e \u0915\u0940 Ankit String tiknA print \u0939\u0941\u090f \u091c\u092c \u0906\u092a \u0907\u0938\u0947 \u0909\u0932\u091f\u0940 \u0924\u0930\u092b \u0938\u0947 Read \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u092f\u0939 \u0938\u0939\u0940 \u0938\u0947 Read \u0939\u094b\u0917\u0940\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"SOUNDEX\"><strong>SOUNDEX(String) <\/strong><\/h2>\n\n\n\n<p>Pronunciation \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 String Return \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e Soundex \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902,    <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, SOUNDEX(stud_nm) from studmst<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"221\" height=\"111\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-49.png?resize=221%2C111&#038;ssl=1\" alt=\"MySQL SOUNDEX\" class=\"wp-image-6288\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT 'Ankeet' as nm1, soundex('Ankeet')  <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"185\" height=\"43\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-51.png?resize=185%2C43&#038;ssl=1\" alt=\"MySQL SOUNDEX\" class=\"wp-image-6291\"\/><\/figure>\n\n\n\n<p>Soundex \u0939\u0930 \u090f\u0915 String \u0915\u093e \u090f\u0915 Number Generate \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a\u0915\u094b \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u092c\u0924\u093e\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0915\u0940 Ankit \u0915\u093e code A523 \u0939\u0948\u0902 \u0964 \u091c\u094b \u0915\u0940 ankeet \u0915\u093e \u092d\u0940 A523 \u0939\u0940 \u0939\u0948\u0902, \u092f\u0926\u093f \u0939\u092e Spelling \u0915\u094b Compare \u0915\u0930\u0947 \u0924\u094b \u0926\u094b\u0928\u094b\u0902 \u0915\u0940 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0939\u0948\u0902 \u0915\u093f\u0928\u094d\u0924\u0941 \u0939\u092e \u092f\u0926\u093f \u0926\u094b\u0928\u094b\u0902 \u0915\u0947 Provocation \u0915\u094b \u0938\u0941\u0928\u0947 \u0924\u094b lagbhag \u090f\u0915 \u0939\u0940 \u0939\u0948\u0902 , \u0907\u0938\u0932\u093f\u090f \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u0941\u091b \u0910\u0938\u0947 string search \u0915\u0930\u0928\u093e \u0939\u094b \u091c\u094b String \u0913\u0930 character wise \u0924\u094b \u0905\u0932\u0917 \u0939\u094b \u0932\u0947\u0915\u093f\u0928 \u0909\u0928\u0915\u093e Pronunciation \u090f\u0915 \u0938\u093e \u0939\u094b \u0924\u092c \u0939\u092e Soundex \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT 'Rahool' as nm1, soundex('Rahool')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"189\" height=\"54\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-52.png?resize=189%2C54&#038;ssl=1\" alt=\"MySQL SOUNDEX\" class=\"wp-image-6292\"\/><\/figure>\n\n\n\n<p>\u091c\u0948\u0938\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0947 Example \u092e\u0947 \u0926\u0947\u0916\u093e \u0920\u0940\u0915 \u0935\u0948\u0938\u093e \u0939\u0940 \u0906\u092a \u0926\u0942\u0938\u0930\u0947 Example \u092e\u0947 \u092d\u0940 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 , \u092f\u0939\u093e\u0901 \u092a\u0930 rahul \u0913\u0930 rahool \u0915\u0947 \u091c\u094b auto generated code \u0939\u0948\u0902 \u0935\u0939 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u090f\u0915 \u091c\u0948\u0938\u0947 \u0939\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"BASE-64\">Base 64 \u0915\u094d\u092f\u093e \u0939\u0948\u0902 ?<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 Network \u092e\u0947 \u0921\u093e\u091f\u093e \u0915\u094b Travel \u0915\u0930\u0935\u093e\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e String \u0915\u094b Base 64 \u092e\u0947 Encode \u0915\u0930 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u0939 \u090f\u0915 6 \u092c\u093f\u091f Encoding \u0939\u0948\u0902 , \u0907\u0938\u0947 base 64 \u0907\u0938\u0932\u093f\u090f \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 64 Characters \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0906\u0907\u090f \u0939\u092e \u0906\u092a\u0915\u094b \u092c\u0924\u093e\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 64 \u0915\u094c\u0928 \u0938\u0947 \u0915\u094c\u0928 \u0938\u0947 Character \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>A &#8211; Z \u0915\u0941\u0932 26 Characters <\/p>\n\n\n\n<p>a &#8211; z \u0915\u0941\u0932 26 Characters  <\/p>\n\n\n\n<p>0 &#8211; 9  \u0915\u0941\u0932 10  Characters    <\/p>\n\n\n\n<p>+ \u0914\u0930 \/ \u0915\u0941\u0932 2  Characters     <\/p>\n\n\n\n<p>26+26+10+2 = 64, \u092f\u0939 \u0938\u092d\u0940 \u0915\u094b \u092e\u093f\u0932\u0915\u0930 64 Characters  \u0939\u094b\u0902\u0917\u0947 \u091c\u093f\u0928\u094d\u0939\u0947 \u092f\u0939 Encode \u0915\u0930\u0947\u0917\u093e \u0964 \u0906\u0907\u090f \u0905\u092c \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 base 64 \u092e\u0947 encode \u0914\u0930 decode \u0915\u0948\u0938\u0947 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p> <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong>TO_BASE64()<\/strong><\/strong><\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 String \u0915\u094b Base64 \u092e\u0947 encode \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f MySQL \u092e\u0947 \u0939\u092e to_base64 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 .  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT stud_nm, TO_BASE64(stud_nm) as stud_base64\nFROM `studmst` <\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"188\" height=\"108\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-42.png?resize=188%2C108&#038;ssl=1\" alt=\"MySQL String Function - TO_BASE64\" class=\"wp-image-6274\"\/><\/figure>\n\n\n\n<p>Ankit \u0915\u094b \u092f\u0926\u093f \u0906\u092a base 64 \u092e\u0947 Encode \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b QW5raXQ String \u0906\u090f\u0917\u0940 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><strong>FROM_BASE64()<\/strong><\/strong><\/h2>\n\n\n\n<p>Base64 Encoded String \u0915\u094b Decode \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964     <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT FROM_BASE64('QW5raXQ=')<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"216\" height=\"49\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/image-43.png?resize=216%2C49&#038;ssl=1\" alt=\"MySQL String Function - FROM_BASE64\" class=\"wp-image-6276\"\/><\/figure>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u091c\u094b String  <strong><strong>TO_BASE64()<\/strong><\/strong> \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0905\u092c  <strong><strong>FROM_BASE64<\/strong><\/strong> \u0938\u0947 \u0907\u0938\u0947 Decode \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u092b\u093f\u0930 \u0938\u0947 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 Ankit String \u0906 \u091c\u093e\u090f\u0917\u0940 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Summary <\/h2>\n\n\n\n<p>\u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 MySQL Function With Example \u0938\u092e\u091d\u0947 \u091c\u093f\u0938\u092e\u0947 \u0939\u092e\u0928\u0947 String \u0915\u0947 Character Count \u0915\u0930\u0928\u093e, String \u0915\u094b \u091c\u094b\u095c\u0928\u093e, Case Change \u0915\u0930\u0928\u093e, \u0914\u0930 \u092d\u0940 \u092c\u0939\u0941\u0924 \u0938\u0947 function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u093e \u0964 <\/p>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b MySQL String Function \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u090f \u0939\u094b\u0902\u0917\u0947 \u092b\u093f\u0930 \u092d\u0940 \u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0915\u094b\u0908 \u092d\u0940 Doubt \u0939\u094b \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 ,<\/p>\n\n\n\n<p>\u092f\u0939  MySQL String Function Article \u0906\u092a\u0915\u094b \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f \u0964 <\/p>\n\n\n\n<p>\u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n","protected":false},"excerpt":{"rendered":"<p>MySQL String Function MySQL \u092f\u093e \u0915\u093f\u0938\u0940 \u092d\u0940 SQL \u092e\u0947 String Manipulation \u0915\u0947 \u0932\u093f\u090f \u0915\u0941\u091b Predefined Function \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u094d\u0939\u0947 MySQL String Function \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948 \u0964 \u0906\u0907\u090f \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e MySQL String Function \u0915\u094c\u0928 &#8211; \u0915\u094c\u0928 \u0938\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948 \u0909\u0928\u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 MySQL String Function With Example \u0938\u092e\u091d\u0924\u0947 \u0939\u0948 \u0964 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6375,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-5355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/01\/MySQL-string-functions.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/5355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=5355"}],"version-history":[{"count":147,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/5355\/revisions"}],"predecessor-version":[{"id":9252,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/5355\/revisions\/9252"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/6375"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=5355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=5355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=5355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}