Announcement

Collapse
No announcement yet.

Find old user posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Find old user posts

    I delete users each semester but keep the posts. When I read the old posts I can see the old usernames. I want to find all the post of an old user (no longer registered). What query do I need to write?
    "The best time to sleep is just before waking up."

    --Shoebuddy Jones

  • #2
    SELECT * FROM post WHERE username='UserName';
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X