Hi,
If you want to search a string "hello" inside a table in a postgres database, try running the snippet below
SELECT * FROM website WHERE to_jsonb(website)::text ILIKE '%hello%';
make sure that you are connected to the database already
Hi,
If you want to search a string "hello" inside a table in a postgres database, try running the snippet below
SELECT * FROM website WHERE to_jsonb(website)::text ILIKE '%hello%';
make sure that you are connected to the database already
For further actions, you may consider blocking this person and/or reporting abuse
Grant Riordan -
Grant Riordan -
Trix Cyrus -
Vaibhav Kulshrestha -
Top comments (0)