Re: Re: enum !!

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...