Ohlamon’s Technology News Blog

LIKE keyword is usually used to search for a string value ( LIKE (‘%STRING%’) ).

If you need to search one field based on the value from another one, the replacing the string value with the column name like this LIKE (%table.column_name%) or some syntax like LIKE (’%'+`table.column_name`+’%')  won’t work.

You need to use the CONCAT operator to make it the correct SQL statement.

LIKE CONCAT(‘%’, table.column_name, ‘%’)

1. Go to the Control Panel - Administrative Tools - Local Security Policy
2. Find  Local Policies - Security Options
3. Change Network security: LAN Manager authentication level to the Send LM & NTLM responses
4. Open Minimum session security for NTLM SSP and uncheck  Require 128-bit encryption

First goto Google and enter your search term. Next, add ‘&as_qdr=d’ to the end of the URL and press enter.

Do you know that 76% of Americans use coupons on a regular basis? And up to 36% of final purchase decisions are influenced by coupons and deals availability. To make a long story short, offering coupons and deals can be a very lucrative business, in fact.

http://scripts.owsdeals.com, a leading deals/coupons website script developer with innovative approaches and professional programmers, announces the launch of its new script for people desiring to set a new online business focused on bargains, offers, deals, and coupons. The script features a code with minimal system requirements (Php and MySql based), RSS feed, a great many options for sorting goods and services by category, store, and listing time, and numerous templates so that web masters can easily customize the site’s look.

You can find best deals on our ows real production OWS Deals/Coupons Website or play with admin panel on the demo site.

People from iphonesimfree.com claim that they finally create software that can completely unlock iPhone from AT&T compatibility only. From now on iPhone could work in T-Mobile and any other GSM network on this planet.

This statement already confirmed by such trusted source as engadget.com.

Also no words on the price for software itself and single unlock yet.

How to disable that really boring “asking confirmation for everything” Windows Vista behavior?

You can get rid of the confirmation by disabling UAC(User Account Control). The problem is that this will disable most of the Windows Vista’s new security features, so be careful with what are you doing.

• Go to Control Panel.
• Click Admin Tools.
• Click System Config.
• Click Tools.
• Disable UAC.