[Beastmode] Like binary - to find uppercase text
![user046467](https://us.v-cdn.net/6032830/uploads/defaultavatar/nZ5X977MOM3Z6.jpg)
When I use the following (example) query it's working fine:
(case when `Product` like '%PROduct1%' then 'Productone' else 'Ignore' end)
Except that product1 also turns up in my results and I only want PROduct1 which uses uppercase letters.
In mysql you can use "like binary" but when I change it to:
(case when `Product` like binary '%PROduct1%' then 'Productone' else 'Ignore' end)
it gives me a syntax error.
Any solution to this?
Comments
-
Hi @user046467
In MySQL (which Domo uses) LIKE is case INsensitive so you're seeing records with both uppercase and lowercase variants on your search string. Domo doesn't support the BINARY flag for LIKE searches either which is why you're getting that error.
If you want case sensitivity you can utilize the INSTR function.
CASE WHEN INSTR(`Product`,'PROduct1') THEN 'Productone' ELSE 'Ignore' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Oh ... let's be clear here, in Beast Modes / Adrenaline, Domo IS NOT using MySQL. Adrenaline is a database engine built on a blend of proprietary and open source technology. The function implementations MIMIC MySQL syntax and functions, but it IS NOT MySQL.
(seems like a stupid point, but MySQL uses row-based indexing and Adrenaline does not AFAIK)
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive