SQL Query
select count(*) from 
ubbt_USER_PROFILE
where USER_LOCATION like '%boo%'

If it's an exact string, you can remove the % around the string. % is a wildcard, so the above would match hooboo, boo, boohoo, etc.