match :this & :that in a string

[racken]

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]*)

Edited January 15, 2013 by racken

[Christian F.]

Actually, that will find all semi-colons, whether or not they have a letter following them. You'll want to use + instead of *, to enforce at least 1 character after the semi-colon.