Ever wanted to do some update on multiple rows with different value or on different condition in a single SQL query? Usually, this can be done by executing some queries in a row as needed. But with MySQL we can do it in a single SQL query. How come?

Sometimes we want to hide some content at first page load to reduce bandwidth transferred to the user. Usually when we just want to show the thumbnails of the image and then the original (big) sized image hidden next to it.

If you are using Mozilla Firefox browser on the latest of Microsoft Windows OS, Windows 7, you may encounter File Access Error while downloading files using DownThemAll plugin. I am using Mozilla Firefox v3.5.4 with DownThemAll v1.1.7.

In this article I will show the difference between the default greedy (.+ and .*) and non-greedy matching using Perl-compatible regular expression.

For example, I have a string in a single line:

$line= "Seq[03] Command : CREATE("A") Seq[04] Command : CREATE("B") Seq[04] error: 5006 Seq[03] error: 5006 Seq[05] Command : DELETE("A") Seq[05] error: 5006 ";

I could capture all the Command without the error code using the following regular expression:

m/Seq\[[0-9]{2}\].+Command.+\(.+\)/gi

If you need to convert Binary String to Decimal (Integer) and Hexadecimal, .NET Framework has conversion methods in Convert class to make numeric conversion easier. This class is located in Microsoft.VisualBasic library.

Network interface can be changed manually by using netsh command (netsh.exe) from Windows Command Prompt. To change the interface IP to static IP, use the following command format:

netsh interface ip set address [Connection Name] [Source] [IP] [Netmask] [Gateway] [Metric]

To apply a simple dreamy effect using Adobe Photoshop is really quick and easy. With only five simple steps. You will be able to make a professional look of dreamy effect photograph from a pale ugly photograph.

Registry Editing has been disabled by your administrator