SuN-80

-- based on UTF-8 Encoding Debugging Chart: http://www.i18nqa.com/debug/utf8-debug.html
UPDATE table SET field = replace(field, '€', '€');
UPDATE table SET field = replace(field, '‚', '‚');
UPDATE table SET field = replace(field, 'Æ’', 'ƒ');
UPDATE table SET field = replace(field, '„', '„');
UPDATE table SET field = replace(field, '…', '…');
UPDATE table SET field = replace(field, '†', '†');
UPDATE table SET field = replace(field, '‡', '‡');
UPDATE table SET field = replace(field, 'ˆ', 'ˆ');
UPDATE table SET field = replace(field, '‰', '‰');

SuN-80

-- In an utf-8 table
UPDATE mytable SET
    field = CONVERT(CAST(CONVERT(field USING latin1) AS BINARY) USING utf8);

SuN-80

UPDATE mytable SET field = replace(field, 'search_for', 'replace_with');

SuN-80

SELECT mytable.id +1
  FROM mytable
WHERE ( mytable.id +1 )
  NOT IN (
	  SELECT mytable.id
	  FROM mytable
  )
ORDER BY id
LIMIT 1;

SuN-80

-- "Lastname, Firstname" to "Firstname Lastname"
UPDATE mytable set field = CONCAT(
  TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(field,',',2),',',-1)),
  ' ',
  TRIM(SUBSTRING_INDEX(field,',',1))
);

SuN-80

-- Find Duplicates and group by duplicated value
SELECT field, COUNT(*)
  FROM mytable GROUP BY field
HAVING count(*) > 1

-- Find Duplicates and list each row
SELECT a.field, a.target_field
FROM mytable a
   INNER JOIN (
     SELECT target_field

SuN-80

formatResult: function (suggestion, currentValue) {
      var keywords = currentValue.split(" ");
      var suggest = suggestion.value;
      $(keywords).each(function() {
          suggest = suggest.replace(new RegExp('(' + this + ')(?![^<]*>|[^<>]*</)', 'gi'), '<strong>' + this + '</strong>');
      });
      return suggest;
    }