Query Postgres JSON array for values in text
On this case you can cast the jsonb as text and use regular LIKE operator.




create table test(data jsonb);
insert into test values ('["Mr Smith","Ms Wellington","Mr Anderson"]'::jsonb);
insert into test values ('["Md Smith","Ms Wellington","Md Anderson"]'::jsonb);
insert into test values ('["Mg Smith","Ms Wellington","Mr Anderson"]'::jsonb);

select *
from   test
where data::text like'%Mr%';





| data                                         |
| :------------------------------------------- |
| [&quot;Mr Smith&quot;, &quot;Ms Wellington&quot;, &quot;Mr Anderson&quot;] |
| [&quot;Mg Smith&quot;, &quot;Ms Wellington&quot;, &quot;Mr Anderson&quot;] |



dbfiddle here