String Functions and Operators
===============================

.. seealso:: :ref:`string-functions-summary`

.. toctree::
   :maxdepth: 2

   string/comparative
   string/conversion
   string/length 
   string/modification
   string/position
   string/other

.. _string-functions-summary:

Summary of Functions
--------------------

'TODO' descriptions
'TODO' "regular functions" ...there are no regular or irregular functions!!!

Comparative and regular functions
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

===================     ====================================================================================================
Operator                  Description
===================     ==================================================================================================== 
LIKE 	              
NOT LIKE 	          
STRCMP() 	          
NOT REGEXP 	        
REGEXP 	            
RLIKE 	            
===================     ====================================================================================================


Conversion and translation functions
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
===================     ====================================================================================================
Operator                  Description
===================     ====================================================================================================
ASCII() 	          
BIN() 	            
CHAR() 	            
HEX()  	            
LOWER() 	          
LCASE() 	          
UCASE() 	          
UNHEX() 	          
UPPER() 	          
===================     ====================================================================================================


Length and size functions
^^^^^^^^^^^^^^^^^^^^^^^^^
===================     ====================================================================================================
Operator                  Description
===================     ====================================================================================================
BIT_LENGTH() 	      
CHAR_LENGTH()       
LENGTH() 	          
OCTET_LENGTH() 	    
===================     ====================================================================================================


Formatting and modification functions
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
===================     ====================================================================================================
Operator                  Description
===================     ====================================================================================================
CONCAT() 	          
TRIM() 	            
LTRIM() 	          
RTRIM() 	          
===================     ====================================================================================================


Position functions
^^^^^^^^^^^^^^^^^^

===================     ====================================================================================================
Operator                  Description
===================     ==================================================================================================== 
FIELD() 	          
FIND_IN_SET() 	    
INSTR() 	          
LEFT() 	            
INSERT() 	          
LOCATE() 	          
POSITION() 	          
===================     ==================================================================================================== 


Other string functions
^^^^^^^^^^^^^^^^^^^^^^

===================     ====================================================================================================
Operator                  Description
===================     ==================================================================================================== 
ELT() 	                 
EXPORT_SET() 	          
FORMAT() 	          
LOAD_FILE() 	          
LPAD() 	                  
MAKE_SET() 	          
MATCH 	              
MID() 	              
ORD() 	             
QUOTE() 	          
REPEAT() 	          
REPLACE() 	        
REVERSE() 	        
RIGHT() 	          
RPAD() 	            
SOUNDEX() 	        
SUBSTR() 	          
SUBSTRING_INDEX() 	  
SUBSTRING() 	        
===================     ====================================================================================================

