472,119 Members | 2,056 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

How to insert a space at the end of a word using CONCAT ?

296 100+

My SQL query is as below -->

Expand|Select|Wrap|Line Numbers
  1. UPDATE rev_log SET keyw=CONCAT(keyw,'  $words  ')
I have put spaces on both sides of $words but only the start space works, the end space doesn't come in the database.

How to do that ?
Jan 6 '07 #1
2 1729
4,258 Expert 4TB
Standard mySQL documentation:
Trailing spaces are removed when CHAR values are retrieved.
Trailing spaces are removed when VARCHAR values are stored.
Ronald :cool:
Jan 6 '07 #2
296 100+
So is there any way that the trailing spaces are not removed ?
Jan 8 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ken Robinson | last post: by
1 post views Thread by Buster | last post: by
10 posts views Thread by Phil Stanton | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.