ARABYAREA.com

CONCAT(str1,str2,…)

Returns the string that results from concatenating the arguments to gother. May have one or more arguments.

Example:

SELECT CONCAT(’FA’, ‘KH’, ‘RI’);

output >> FAKHRI

1. mysql ASCII function
   mysql ASCII function keyword is used to return the numeric value of the leftmost character of the string 'str'. Returns 0 if 'str' is the empty string and  returns NULL if...
2. mysql string replace function in query
   mysql REPLACE function can be used as the following: replaces the string from_str with the string to_str examples : replace string in all records in tablename: update tablename set fieldname =replace...
3. mysql BIT_LENGTH(str) function
   BIT_LENGTH(str) function Returns the length of the string str in bits Example: SELECT BIT_LENGTH('text');...
4. mysql CHAR_LENGTH(str) function
   CHAR_LENGTH(str) function Returns the length of the string str, measured in characters. A multi-byte character counts as a single character. Example SELECT CHAR_LENGTH(Name)...
5. mysql SUBSTRING function keyword
   mysql SUBSTRING function keyword, it used to split the string for a field into sub strings.  SUBSTRING (Field) Return the substring as specified SQL Code Examples: Select SUBSTRING (name,0,3) where 1 ; returns...
6. get free file name function with php
   Some times in when make a code for uploading files, you want that the uploaded file not to be over written, to do that you have to use this function....
7. Javascript IsNumeric validator function
   This function is used to test a value stored in the parameter inputText is it numeric or not, in other words is it contains characters other than 1,2,3,4,5,6,7,8,9,0 ? if...
8. How to Crop a Group of Images or resize Group of Images using photoshop
   Sometimes when you want to upload photos to the Web, or to send them via email , it is better to scale them down to a smaller size, so your recipient...
9. Cannot select or format a hard disk partition when I try to install Windows Vista
   Cannot select or format a hard disk partition when I try to install Windows Vista:  When you try to install Windows Vista to your computer, you may experienced by one or...
10. YouTube Downloader free download
    Author : FDRLab Data Recovery Centre Download Size : 2775 KB Want to download videos from YouTube or Google Video? you have to download YouTube Downloader and install it...