Forum OpenACS Development: Re: acs-lang searching values of message keys for a locale

select * from example_table where title in (select message_key from lang_messages where package_key = 'acs-translations' and locale = :user_locale and message like '%:searchterm%')