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! ).