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
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
Do I need to use PHP to assess this?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
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
.
- 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 little stuc
Hey guys,
I am a little stuck here, i know how to botch a solution together using a
bunch of queries and PHP manipulation, but i am sure there is a more elegant
way to do this one;
i have some tables (i won't put their full defs, just bits that are relevant
(they are huge))
TABLE students
FIELDS
"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]
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 date_online <=
'
>___
>
> > $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
ct: Re: [PHP-DB] Select where
>
>
>
> - 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
- 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
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
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 = 'deceased';
I getMySQL said: You have an error in your
21 matches
Mail list logo
