Postgres - searching query

Question

Hello i am trying to make a searching tool for links. But when my query face with (/) return no result.

SELECT source FROM streams
where source::text ilike '%http://:999/Users-personal/ezample23456789/2520512%';

When i try to find 'http' is working fine

The column is json

Answer 1

Please try the below query.

SELECT source FROM streams where source::text ilike '%http%://:999/Users-personal/ezample23456789/2520512%';