Use LIKE statement with variables in SQL

Queries and Resources
,
1

  • Goal: trying to build a workflow

  • Steps:

  • Details:

  • Screenshots:

  • App json export:

How can I use LIKE statement with a variable?

image

2

Does the error ask you to enable the prepared statements on your resource? That could be one issue.

Also, in the past I've built the query you are trying to execute as ... LIKE {{'%' + query.data + '%'}} which would be different than the format you are using.

4 Likes
3

Thank you so much @pyrrho, following your format it runs successfully.

2 Likes