Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 May 2014, 15:21
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Question SQL query for specific text in homepage field

Can someone help me create a query that lists all users with a specific string of characters in the homepage field? I have a spammer that has the word barbara in a URL of the home page.

I've tried


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

It doesn't give me an error, but it gives me 0 results. If I change to 'http%' which I know there are lots of, it still gives me 0 results. Obviously I'm doing it wrong. If I do an empty query with two single quotes, it works to give me all users without a homepage.



Thanks in advance.
Reply With Quote
  #2  
Old 23 May 2014, 15:38
nhawk nhawk is offline
 
Join Date: Jan 2011
Try this..


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #3  
Old 23 May 2014, 16:43
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Duh. I should have seen that. Thanks for the slap across the face. It works. :-)
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add Homepage Field to Registration Christine vBulletin 3.0 Full Releases 6 29 Feb 2004 12:48



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:15.

Layout Options | Width: Wide Color: