How to do a query with a LIKE?

Troubleshooting
1

Hello,

I would like to write a query that acts like a SQL statement with a LIKE (charater %). So I tried something like:

page where name = 'Test%'

I would like to get back any page that has a name like Test, Test123 or Test 123. Sadly the % isn’t interpreted and there is no LIKE operator/statement. So how can I do this? Maybe I do it wrong.

At Query Language I found no example like this as well. I also found no forum threads about this.

Thank you for your help.

Best Regards,

2

There is the =~ regex match operator you can use for similar things: where name =~ /Test.*/ for example.

1 Like
3

Thank you. I didn’t expect that I need a regex for this. This works as expected.

1 Like