I'm trying to make some regex that will find all the cases of words which start with a :
I have (:[a-zA-Z]) which just finds the first letter atm I've no idea how to find the whole word
For an example string
SELECT * , u.nick FROM webid_useraccounts
LEFT JOIN webid_users u ON (u.id = webid_useraccounts.user_id)
WHERE user_id = :user_id ORDER BY date LIMIT :OFFSET , :perpage
it would return :user_id, :OFFSET and :perpage
EDIT: nvm I was just being thick I missed the *. It should of been (:[a-zA-Z]*)