TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Showing results 1 to 2 of 2
Search took 0.02 seconds.
Search: Posts Made By: Sand_Devil
Forum: MySQL & Databases 04-05-2008, 04:25 AM
Replies: 6
Views: 1,446
Posted By Sand_Devil
If I understand what you are suggesting... word...

If I understand what you are suggesting... word being the entered string and blah_field being the database entry. || allows you to concatenate strings. To search for the % you need to place an...
Forum: MySQL & Databases 11-30-2007, 10:54 PM
Replies: 16
Views: 8,973
Posted By Sand_Devil
I've always found COALESCE to be very useful. 6:...

I've always found COALESCE to be very useful.
6: COALESCE

Returns the first non null entry
SELECT COALESCE (column1, column2, '') from table

Result: if column1 not null, then returns column1, if...
Showing results 1 to 2 of 2

 

All times are GMT. The time now is 02:12 AM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design