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


Well-known member
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.