Log in

View Full Version : Need a sql query


Max Taxable
11-06-2011, 02:41 PM
I'd imported a SMF database and all went well, except for one irritant. Words in posts that have contractions in them, the apostrophe is replaced by & # 3 9 ;

As in, "let's go to the store" or, "that's cool" etc.

What query would I need to replace & # 3 9 ; With a apostrophe, globally?

--------------- Added 1320618589 at 1320618589 ---------------

Anyone?

Max Taxable
11-08-2011, 12:40 AM
Thanks for the PM BirdOPrey5 your suggestion was spot on.