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

XF 1.3 How do I replace spelling, case of a word in thread titles?

Discussion in 'XenForo Questions and Support' started by cmeinck, Jul 30, 2014.

  1. cmeinck

    cmeinck Well-Known Member

    I run an iPhone forum and often I see people post threads using incorrect case. For example, I'll see threads with iphone or Iphone.

    Is there a mySQL query I could run on thread titles only that would allow me to replace 'iphone' with 'iPhone'?
  2. AndyB

    AndyB Well-Known Member

    In phpMyAdmin you would enter:

    UPDATE xf_thread SET title = REPLACE(title, 'iphone', 'iPhone')
    cmeinck and jamalfree like this.
  3. cmeinck

    cmeinck Well-Known Member

    Awesome, thanks!

Share This Page