Data Studio
4.5K members online now
4.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

LIKE SQL query not working in custom dimension for data studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

The following valid SQL query doesn't work, but if I change the like to = and remove the % characters it will. How can I get the like statement to work?

 

CASE WHEN Landing Page LIKE'site-section' THEN 'Section' ELSE 'Non-Section' END

 

 

1 Expert replyverified_user

Re: LIKE SQL query not working in custom dimension for data studio

Google Employee
# 2
Google Employee
Data Studio does not support all SQL functions. It does not support LIKE.

You can do this using REGEXP_MATCH instead.

For more, please see https://support.google.com/360suite/datastudio/table/6379764