Which mysql function is used to concatenate string?

Answer Posted / hrindows@gmail.com

CONCAT() function is used to combine two or more string data. The use of this function is here with an example.
Example: The following SELECT query with CONCAT() function will combine five words, ‘Welcome ‘, ‘to’, ‘SoftwareTestingHelp’,’.’ and ‘com’.

SELECT CONCAT('Welcome ',to ','SoftwareTestingHelp','.',com');

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is mysql data stored?

656


What is mysql enterprise edition?

687


What are the benefits of mysql?

709


What are the advantages/disadvantages of mysql and php?

706


What is the maximum connection pool size?

744


how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

721


How do you backup a database in mysql?

782


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

795


Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

711


How to dump one database for backup.

708


How to get the number of rows selected or affected by a sql statement?

710


How do I create a stored procedure in mysql?

683


How to create a table?

730


How to enter binary numbers in sql statements?

743


What does mysql_fetch_assoc do?

730