• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 How To Find Entries in a Custom User Field?

DRE

Well-known member
#1
Sup. I created a custom user field value called "books". I also created one called "comics".

I no longer want "comics". I need to find all the users who entered "comics" in their custom user field.

After I find the users who added to comics, I'll take their answers and add it to books.

What's a query to run that?

SELECT * FROM xf_user_field_value WHERE comic = ""

That's where I'm lost at.