SELECT * FROM projects WHERE link REGEXP '[scriptlance]'

update projects set source=3 WHERE link REGEXP '[scriptlance]'

update projects set source=1 WHERE LOWER(link) LIKE '%getafreelancer%'
LOWER(content) LIKE '%$search%'

http://www.getafreelancer.com/projects/ncl05_1268200373.html
SELECT siteDomain FROM lucene_hosts WHERE siteId='".."';