Martin AJ questions

• How can I select a box which has specific text?
• How can I remove DOM element tags but leave their contents?
• What's the meaning of RESTRICT in Foreign Keys?
• What happens when I create an index on a column?
• Classifying date as "yesterday", "last week", etc
• Are triggers transaction?
• How to set inner element border upon the outer one?
• How can I get ids of grouped rows?
• Can a query only use one index per table?
• How can I select the last edited version of a post?

Martin AJ answers