vb.org Archive - mySQL - trim leading / trailing blank space from POST table's "pagetext" column

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - mySQL - trim leading / trailing blank space from POST table's "pagetext" column (https://vborg.vbsupport.ru/showthread.php?t=198120)

Rik Brown

12-06-2008 03:50 AM

mySQL - trim leading / trailing blank space from POST table's "pagetext" column

I've been trying to run a mySQL query to trim leading and trailing blank spaces in the pagetext column of the posts table in order to clean up the presentation of the post data. I've been testing the following query on a single post:

UPDATE `post` SET `pagetext` = TRIM(pagetext) WHERE postid = '427517';

I don't see anything wrong with the query. However, it nukes the entire line of data for any specific post. Does anyone know what I'm doing wrong?

Thanks. -- Rik

luki	12-08-2008 05:31 AM

Try:

Code:

UPDATE post SET pagetext = TRIM(BOTH ' ' FROM pagetext) WHERE postid = 1;

Rik Brown

12-08-2008 06:51 AM

Quote:

Originally Posted by luki (Post 1680728)

Try:

Code:

UPDATE post SET pagetext = TRIM(BOTH ' ' FROM pagetext) WHERE postid = 1;

Lukas:

That worked perfectly. Cleaned up thousands of pages in just a minute.

Thanks a lot! -- Rik

All times are GMT. The time now is 06:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01043 seconds Memory Usage 1,712KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: