MySQL Forums
Forum List  »  Newbie

underscores and joining tables
Posted by: Thomas Stieve
Date: December 07, 2017 04:41PM

Hello,

I have two tables which I want to join using primary keys that consists of titles. The title is the same in both tables, but one has underscores where there are spaces in the other table. I've tried to replace the underscore with a space. This appears to work visually, but I can't join them. They don't match. When I run a select query for underscores, the titles which I replaced the underscores are returned, even though it visually shows spaces. I have no clue what's happening.

Any help is much appreciated!
Tom

Options: ReplyQuote


Subject
Written By
Posted
underscores and joining tables
December 07, 2017 04:41PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.