Trim

I'm using phpmyadmin and I need to trim a space from the password field on all users on company 5133.

trim(Password)from ENT_ED WHERE CompanyNumber = "5133" the space is at the end of the password

it's not working

please help
rcleonAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rik-LeggerConnect With a Mentor Commented:
This part of your query seems right,
but maybe you can post the whole query and/or the result you are getting.

Does this give you the expected result?
SELECT trim('  bar   ');

Open in new window

0
All Courses

From novice to tech pro — start learning today.