Quick Search:
 mySQL: Add string to field Jump to:  
Category: >> mySQL >> Add string to field  

<< lastnext >>

Snippet Name: Add string to field

Description: 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.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

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

   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org