On 4 December 2010 11:40, Amit Tandon wrote:
> Dear Ron
>
> Or try this
>
> SELECT * FROM `paypal_payment_info` WHERE ifnull(os1, '') <>
> 'commission_paid'
>
> regds
> amit
>
> "The difference between fiction and reality? Fiction has to make sense."
>
>
> On Sat, Dec 4, 2010 at 7:55
Dear Ron
Or try this
SELECT * FROM `paypal_payment_info` WHERE ifnull(os1, '') <>
'commission_paid'
regds
amit
"The difference between fiction and reality? Fiction has to make sense."
On Sat, Dec 4, 2010 at 7:55 AM, Ron Piggott
wrote:
>
> When I do the following query in mySQL on
On Fri, Dec 3, 2010 at 6:25 PM, Ron Piggott
wrote:
>
> When I do the following query in mySQL only 1 record is retrieved.
>
> SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid'
>
> I am surprised by this. This one record has no characters in it, but the
> “INSERT INTO” th
When I do the following query in mySQL only 1 record is retrieved.
SELECT * FROM `paypal_payment_info` WHERE `os1` NOT LIKE 'commission_paid'
I am surprised by this. This one record has no characters in it, but the
“INSERT INTO” that created it used: ( `os1` ) VALUES ( ‘’ ) instead of: ( `o
I have a loop process that reads a record out of a flat file, stores the
data for a given record in an array, writes the record to the db, resets the
data in the array, then iterates again thru the loop. Not every record has a
value for each field. For example,
Not every record has a value for th