MySQL joins are not case-sensitive!
user022825
⚪️
in Dataflows
I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and my team. Here's an example:
table_1:
team | manager_id |
Sales | John123 |
Marketing | Joe341 |
table_2:
location | manager_id_2 |
Michigan | John123 |
California | JOhn123 |
Texas | JOHN123 |
select table_1.*, table_2.* from table_1 left join table_2 on table_1.manager_id = table_2.manager_id_2
I get:
team | manager_id | location | manager_id_2 |
Sales | John123 | Michigan | John123 |
Sales | John123 | Michigan | JOhn123 |
Sales | John123 | Michigan | JOHN123 |
Marketing | Joe341 |
Can anyone tell how to make the join case sensitive?
0
Comments
-
Hi @user022825
You can utilize the BINARY keyword to force MySql dataflow to do a case sensitive join.
select table_1.*, table_2.* from table_1 left join table_2 on BINARY table_1.manager_id = table_2.manager_id_2
**Was this post helpful? Click the heart icon**
**Did this solve your problem? Accept it as a solution!**1
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 296 仲間に相談
- 649 ひらめき共有