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

[DRE]

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.

 

[DRE]

Anyone?

 

[DRE]

Nvm found the answer lol @ me asking this already before http://xenforo.com/community/thread...r-fields-that-have-been-filled-by-user.47928/

SELECT *
FROM  `xf_user_field_value`
WHERE  `field_id` =  'xbox_gametag'
AND  `field_value` !=  ''