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

Given a table column containing acs-lang message_key values in place of short paragraphs of text, such as:

set example_table.title = '#package-key.${unique_id}#'

according to 'i18n methods for short strings': https://openacs.org/forums/message-view?message_id=296504

How does one code a search for the values in a il8n'd column in context of a user's 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%')