MySQL Forums
Forum List  »  Newbie

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


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!

Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.