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
to
> your efforts.
>
> In the example you have given below, you would probably want to use LIKE.
> For example, "SELECT * FROM test WHERE cat LIKE '%c%';" or similar ought
to
> do it. Of course, I hope that the example is merely an example because if
> you really designed a production table like that then you wouldn't be
> taking advantage of the "relational" part of your relational database
> management system.
>
> So please keep learning SQL...it's a fantastic skill to have. If you have
> a specific SQL problem every once in a while there are those on this list
> who would undoubtedly enjoy helping out. Several beginner-level questions
> back-to-back, though, is way beyond the charter of this mailing list. The
> overall purpose of this particular mailing list is for discussions about
> PHP's ability to interface with databases. There may possibly be an SQL
> beginners mailing list on egroups or someplace similar...you might find an
> environment like that better than the PHP-DB list to help you with this
stuff.
>
> Doug
>
> At 02:56 PM 7/16/01 -0400, McShen wrote:
> >ok. I use set to make a table. here is my table 'test'
> >+-------+------+
> >| name | cat |
> >+-------+------+
> >| shen | a,c |
> >| shen1 | b,c |
> >+-------+------+
> >
> >How can I find all records that contain 'c'?
> >i tried
> >select * from test where cat='c';
> ...snip...
>
>
--
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]