Is ther any way to TRIM a field as i can do it in PHP

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Locked
Erazor2
Forum Newbie
Posts: 5
Joined: Mon Mar 24, 2003 9:17 am
Location: Bavaria
Contact:

Is ther any way to TRIM a field as i can do it in PHP

Post by Erazor2 »

Hi 2 all,

I have a problem trimming my fields with the trim() function in PHP,

is ther any way to do this directly in MySQL?

maybe trim("column")??

I used google but I couldn't find anything

I hope you can help me!
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

Probably best to keep this thread in one place:
viewtopic.php?t=7448
(It'll just get confusing otherwise)

Mac
Locked