Add string to field

Submitted by:David Villa

Date added:21 September, 2011

Category:MySQL

Allows you to add a string to end or start of a field to use when comparing or selecting data. The second argument is added to the end of the first

Tags: add string

Code Snippet:

SELECT * FROM `table` WHERE `field` = CONCAT(field2, '_hello')
 
 

Comments