On Wed, Mar 9, 2011 at 17:49, Ron Piggott
wrote:
>
> Is there a command in mySQL that would allow me to SELECT the rows where the
> `fax` column is more than 11 characters long?
There is.
SELECT * FROM tblName WHERE CHAR_LENGTH(fax) >= 11;
(Presuming you meant greater than or equal
Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char-length
On Thu, Mar 10, 2011 at 9:49 AM, Ron Piggott wrote:
>
> Is there a command in mySQL that would allow me to SELECT the rows where
> the `fax` column is more than 11 characters long?
>
> OR
>
> D
I think I forgot something usefull...
- Original Message -
From: "Beau Lebens" <[EMAIL PROTECTED]>
To: "PHP DB (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 3:59 AM
Subject: [PHP-DB] SELECT where something exists but something else does not
> Hey guys,
> I am a lit
Hi!
I think I have solved your problem...
I have attached an sql file to create the sample DB I created for my test
and a PHP file for you to run to see how I have implemented it.
First create the tables with the .sql file an then execute the .php file
from your browser.
Hope these help.
---
"boclair" <[EMAIL PROTECTED]> wrote in message
005101c0b2d2$4e6b3920$[EMAIL PROTECTED]">news:005101c0b2d2$4e6b3920$[EMAIL PROTECTED]...
|
| - Original Message -
| From: boclair <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, March 22,
- Original Message -
From: Steve Brett <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 11:04 PM
Subject: RE: [PHP-DB] Select where date is in period
> i think i also used >= to indicate 'equal o
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 10:45 PM
Subject: Re: [PHP-DB] Select where date is in period
>
> ___Morris___
>
> The database has a table of equipments with date fields for
> d
Message-
> From: boclair [mailto:[EMAIL PROTECTED]]
> Sent: 22 March 2001 12:45
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Select where date is in period
>
>
>
> ___Morris___
>
> The database has a table of equipments with date fields for
> date_
dicated by an authorised representative independently of
this message."
Egton Medical Information Systems Limited. Registered in England. No
2117205.
Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth,
Leeds, LS18 4RF
> -----Original Message-----
> From: bocl
___Morris___
The database has a table of equipments with date fields for
date_online and date_offline.
The requirement is to find which equipments were available on a date
specified by the user, this being a variable created by the user.
My attempts at scripting for the condition where the dat
BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
>___
>
> > $query = "SELECT * FROM members where status='deceased'"
> >
> > Then just call the $query in your script
>___
>
>Thanks, I only gave the mySQL but the php scripting is
>
>
>$deceased = mysql_query(SELECT * FROM members where
>status=\'de
Tim,
Your missing a double quotation prior to your SELECT.
Further, are you connected to a database? :
$result=mysql_query($sql,$db);
Chris
> -Original Message-
> From: boclair [mailto:[EMAIL PROTECTED]]
> Sent: 20 March 2001 14:54
> To: [EMAIL PROTECTED]
> Subje
- Original Message -
From: Darryl Friesen <[EMAIL PROTECTED]>
To: boclair <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 1:22 AM
Subject: Re: [PHP-DB] Select where
> > Thanks, I only gave the mySQL but the php scripting is
> &g
> Thanks, I only gave the mySQL but the php scripting is
>
> $deceased = mysql_query(SELECT * FROM members where
> status=\'deceased\'");
> and later
> while ($myrow = mysql_fetch_row($deceased))
>
> MySQL now says in relation to the *while* line
> Warning: Supplied argument is no
- Original Message -
From: boclair <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 21, 2001 12:02 AM
Subject: [PHP-DB] Select where
> This is simple but I cannot see where I am going wrong
>
> I have a table members with one of the fields
> status, varchar(10)
>
> Th
On Wed, 21 Mar 2001, boclair wrote:
> This is simple but I cannot see where I am going wrong
>
> I have a table members with one of the fields
> status, varchar(10)
>
> The values may be active or retired or deceased or null
>
> If I run the select
>
> SELECT * FROM members WHERE status = 'd
17 matches
Mail list logo