<SQL> remove spaces from field data in the database

(1) MySQL replace function

Syntax: replace (object,search,replace)

Meaning: Replace all occurrences of search in object with the Replace

Case:

SQL Code copy content to clipboard

1. Update ' News ' Set ' content ' = Replace (' content ',',');//clear spaces in the content field in the news table

(2) MySQL trim function

Syntax: Trim ([{BOTH | Leading | TRAILING} [REMSTR] from] str)

The following examples illustrate:

SQL Code copy content to clipboard

1. mysql> SELECT  TRIM (' phpernote ');

2. ' phpernote '

SQL Code copy content to clipboard

1. mysq l>  select ' x ' from &NBSP; ' xxxphpernotexxx '

2. ->  phpernotexxx '   

sql Code copy content to clipboard

1. mysq l>  select ' x ' from &NBSP; ' xxxphpernotexxx '

2. ->  Phpernote '   

sql Code copy content to clipboard

1. mysql> SELECT  TRIM (TRAILING ' xyz ' from ' phpernotexxyz ');

2. ' Phpernotex '

<SQL> remove spaces from field data in the database