PDA

View Full Version : How to search a text string in the post table


David_R
05-25-2012, 05:11 PM
Hello,

How I can search a text string in the post table.

I have lots of URL (www.example.com) made by some users, but i am not able find all of them using the normal vbulletin search.

Hence I want to make a search in the post table in someway please help !!!

Lots of spammers are screwing our site, and I want to delete this immediately.

Regards.

Badshah93
05-25-2012, 05:35 PM
SELECT * FROM post
WHERE pagetext LIKE '%www.example.com%'