Searching User Profile Fields

[Steve Hoffmeyer]

Is there any way to do a Greater Than ">" or Less Than "<" search on a User Profile Field?

I would like to add a private User Profile Field "Expiration Date" to my forum, and be able to search this for for members who's Expiration Date has lapsed.

In other words I would like to put something like "<20090906" in the search for users section to extract users whose Expiration date is less than 9/6/2009.

[Lynne]

There is no way to do a search on the Search for Users page like you are asking. You would have to do a query for it.

[Steve Hoffmeyer]

Hi Lynne,
Thanks for your reply.
How do you do a query?
Steve

[Lynne]

A MySQL query? You can go to the mysql site and see lots, or google "mysql select" and find how to make a select statement in mysql. I don't write queries for people cuz I'm a trial and error coder and I'm not gonna write something for someone that then screws up their database (I'll gladly do it to my own database, but not someone elses! :) ).