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

[cmeinck]

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'?

 

[AndyB]

In phpMyAdmin you would enter:

UPDATE xf_thread SET title = REPLACE(title, 'iphone', 'iPhone')

 

[cmeinck]

Awesome, thanks!