PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Monday, July 16, 2001 3:40 PM
Subject: Re: [PHP-DB] Re: enum !!
>
>select * from test where cat like 'c'
>
>or, a little broader
>
>select *from text where cat like '%c%'
>
>Miles Thompson
&g
thx alot!
"Doug Semig" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I applaud your efforts to learn SQL.
>
> I wonder, though, if the PHP-DB list the best place to learn SQL. I would
> think that a book or a web-based tutorial on SQL would be more conducive
I applaud your efforts to learn SQL.
I wonder, though, if the PHP-DB list the best place to learn SQL. I would
think that a book or a web-based tutorial on SQL would be more conducive to
your efforts.
In the example you have given below, you would probably want to use LIKE.
For example, "SELE
ROTECTED]> wrote in message
> > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > >
> > > First normal form (1NF), A table in which the intersection of every
>column
> > > and record contains one, and only one, value.
> > >
> > >
> >
" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> >
> > First normal form (1NF), A table in which the intersection of every column
> > and record contains one, and only one, value.
> >
> >
> -Original Message-
> From: McShen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 16, 2001 1:56 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Re: enum !!
>
>
> ok. I use set to make a table. here is my table 'test'
> +---+--+
> | na
>
> > First normal form (1NF), A table in which the intersection of every
column
> > and record contains one, and only one, value.
> >
> >
> >
> > -Original Message-
> > From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
> > Sent: 16 July 2001 1
;
>
> -Original Message-
> From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
> Sent: 16 July 2001 19:21
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: enum !!
>
>
>
> "McShen" <[EMAIL PROTECTED]> wrote in messa
First normal form (1NF), A table in which the intersection of every column
and record contains one, and only one, value.
-Original Message-
From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2001 19:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: enum !!
"McShen&quo
"McShen" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> how do i store multiple data in one field?
> i have a table like this
>
> +---+---+--+-+-+---+
> | Field | Type | Null | Key | Default | Extra |
> +---
10 matches
Mail list logo