Author: admin

[MySQL] How to use Column Name Inside The LIKE Statement

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,...

Read More

iOS 6 New Features

Chinese service integration Facebook integration FaceTime over 3G/4G Flyover and turn-by-turn GPS Guided Access Made for iPhone hearing aids New content stores Offline Reading List Passbook Phone replies and reminders Safari tab syncing Shared Photo Streams Siri VIP list flagged/VIP...

Read More

Adobe Photoshop CS6 beta available

Adobe released the new beta version of its popular photo/image editing software. Adobe Photoshop CS6 is available for free download at Adobe Labs New version includes several major enhancements like new “Dark” interface, “Content-Aware Patch” that allows you to easily work with objects and backgrounds. Adobe also promises fast performance and new design tools....

Read More