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

XF 1.2 How to query the database where the signature is stored?

Discussion in 'XenForo Questions and Support' started by RoldanLT, Jan 10, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    So I'd like to search on the signature field of all my forum user's.
    This bbcode [photo] was use by Xengallery addon.

    I want to search if who else are using this code on their signature and modify them one by one.
    I have 140K of user's and I think only a few are using the bbcode.
  2. Brogan

    Brogan XenForo Moderator Staff Member

    SELECT * FROM xf_user_profile WHERE signature LIKE '%[photo]%'
    RoldanLT likes this.
  3. RoldanLT

    RoldanLT Well-Known Member

    Done, MySQL returned an empty result set (i.e. zero rows). (Query took 0.1385 sec)

    Thanks (y)

Share This Page