How to add a prefix to a field’s value
Posted on August 30, 2008, under PHP, 
Bookmark it
Greetings,
Ever wanted to add a preffix to a mysql field’s value? The CONCAT string function can help you. Here’s how you can do it:
UPDATE `your_table` SET field_name = CONCAT('my prefix here ', field_name)
where field_name='the field value here'; #optional condition
Example: You can use this command to add a prefix for a telephone number.
Good luck!
Do you wish to receive the latest updates as soon as they are posted? Get our RSS Feed or Subscribe to the Newsletter!
- August 30, 2008
- article by Gabriel C.
- 1 comment
Related Posts
-
How to add a suffix to a field’s valueat August 30, 2008
-
Checking the beginning of a string (prefix)
at August 30, 2008 with 1 comment
-
Update table field by replacing a string value with a new one
at August 28, 2008
-
Create, Customize and Send Newsletters: MeeNewsat August 3, 2009 with 3 comments
-
How to make an alphabetical search
at August 30, 2008
-
AJAX Form with CAPTCHA, Realtime Validation and PHP BackendPublished on 09.02.08, 537 replies.
-
Dynamic Dependant DropDown List: US States & CountiesPublished on 11.06.08, 83 replies.
-
An AJAX (jQuery) Username Availability Checker with PHP Back-endPublished on 12.05.08, 61 replies.
-
How to Implement a jQuery AJAX Login Form into a Modal BoxPublished on 04.24.09, 85 replies.
-
How to Add Multi-language Support to a PHP WebsitePublished on 07.23.09, 83 replies.
-
10 Mistakes Info-Marketers Need To Know And Avoid In Order To Succeedby Gabriel C. on February 3, 2012
-
In-Depth Instant CSS Documentation Search: InstaCSS
by Gabriel C. on December 2, 2011
-
Factors to Consider When Choosing a Font
by Gabriel C. on November 15, 2011
-
Bootstrap: Kick-start Development of Webapps and Sites
by Gabriel C. on November 8, 2011
This is a great application. But Gabriel you prommised me a database "updated version" laston February 5th, 2012 by Llewellyn
Also will not work in this example: www.google.com/?secondwebsite.com/site.phpon January 7th, 2012 by dewdwtf2
For people who seem to be receiving auto responder emails twice, the issue can beon December 30th, 2011 by Donina
That include_once 'languages/'.$lang_file; always generates a break line on top of HTML. How can i preventon December 8th, 2011 by M4x1m0v3r
- AJAX (20)
- Design (16)
- Flash (19)
- Freebies (10)
- General (17)
- Graphics (22)
- HTML & CSS (33)
- Frameworks (8)
- JavaScript (142)
- Frameworks (5)
- jQuery (74)
- MooTools (13)
- Photoshop (3)
- PHP (103)
- Reviews (5)
- Statistics (2)
- Web Tools (8)
- Wordpress (16)
- February 2012
- December 2011
- November 2011
- October 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- May 2008
Tag Cloud
- ajax form builder
- ajax login
- alphabetical
- array
- auto grow
- base
- calculate
- captcha
- chart
- charts
- countdown
- css framework
- delimiters
- documents
- dropdown
- extension
- extract
- filename
- fonts
- form
- gd library
- icon set
- iphone
- lightbox
- modal box
- mod_rewrite
- percent
- Photo Gallery
- picker
- random
- remove
- script.aculo.us
- search
- shopping cart
- skin form elements
- slider
- syntax highlighter
- tableless
- to-do
- validate
- web analytics
- web fetch
- WYSIWYG
- zoom
One Reply to "How to add a prefix to a field’s value"
November 27, 2009 at 12:19 PM
Brilliant tip worked a treat.