Advertisement
joachip

SQL trims spaces from the end of varchar fields!

Oct 6th, 2015
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.43 KB | None | 0 0
  1. select id, title, category from ratings where title=' spaces';
  2. +-----+----------+----------+
  3. | id  | title    | category |
  4. +-----+----------+----------+
  5. | 342 |  spaces  |        1 |
  6. +-----+----------+----------+
  7.  
  8. select id, title, category from ratings where title=' spaces   ';
  9. +-----+----------+----------+
  10. | id  | title    | category |
  11. +-----+----------+----------+
  12. | 342 |  spaces  |        1 |
  13. +-----+----------+----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement