469,658 Members | 1,680 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

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

296 100+
Hi

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 1697
ronverdonk
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
pankajit09
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 gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.