UPDATE `table_name` 
SET `field_name` = (SELECT CASE `field_name` WHEN 1 THEN 0 ELSE 1 END) 
WHERE `id_column` = 1

Or with text strings

UPDATE `table_name` 
SET `field_name` = (SELECT CASE `field_name` WHEN 'foo' THEN 'bar' ELSE 'foo' END) 
WHERE `id_column` = 1

If you love getScript as a shortcut method in jQuery, but you hate not being able to control whether the script calls from the browsers cache or not then you can override the built-in function with a new one which is backwards compatible, so it won’t break any of your old code, and allows you to choose true or false to caching.

Read the original post by Jamie Thompson (via Internet Archive)

(function($){
$.getScript = function(url, callback, cache){
	$.ajax({
			type: "GET",
			url: url,
			success: callback,
			dataType: "script",
			cache: cache
	});
};
})(jQuery)

[carousel keywords=”jquery” tag=”fetchit-21″]

The share buttons that are currently offered by sites such as Digg, Facebook and Tweetmeme all have something in common when it comes to their height. 61px seems to be a developing standard.

The problem is that when you line them all up the Facebook share button is actually wider than the others which seem to come in at 52px.

Well you can make the Facebook button 52px in width without too much trouble. Facebook only use two classes to style the inner ‘Share’ button which seems to be the decider when it comes to the buttons width.

By shaving a little off the left and right padding we can bring the Facebook share button back down to 52px in width and make it play nice with the other share buttons.

The extra span is just enough to beat the included Facebook css with a higher specificity score by 1 single point.

[carousel keywords=”facebook development” tag=”fetchit-21″]

Sometimes OS X won’t let you change the owner of file using Finder. Annoying. Here are the simple steps to do it in Terminal.

First if you are just looking for the command it’s:

sudo chown -R _new_owner /root/to/file.txt

Where _new_owner is the name of the new owner you want to assign to the file

Now the steps:

1. Open Terminal, which you will find in Applications -> Utilities
2. Type in sudo chown -R _new_owner
3. Type the file path OR drag the file from finder onto the line after _new_owner to make the path appear.
4. Hit the enter key
5. You may have to type your OSX login password if prompted
6. Repeat for any other files you want to change