Userfields query at The Staff Lounge - Learn more about vBulletin at The Staff Lounge. Your resource for vBulletin support, styles and forum administration. Your vBulletin Resource.

44 views Published 5 months, 3 weeks ago in vBulletin Tips

I have lots of queries like this:

SELECT COUNT(*) AS users
FROM user AS user
LEFT JOIN userfield AS userfield USING (userid)
WHERE 1=1 AND field13 LIKE ‘%search parameters%’
AND …

Tags: No tags for this post. Print This Post

Search

Forum Reviews
Professional feedback.

Forum Articles
Quality articles.