DEV Community

Jeevachaithanyan Sivanandan
Jeevachaithanyan Sivanandan

Posted on

postgresql : search full text inside a table

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

Top comments (0)