Reputation: 21489
Is it possible to search a field that was serialized in php and stored like that in postgresql ?
Upvotes: 0
Views: 375
Reputation: 53591
You can use the regexp match, but it won't be fast:
select * from table where field ~* 'sometext';
Upvotes: 1