Welcome to the Monastery | |
PerlMonks |
Re: Re: Pulling out information for MySQLby gryphon (Abbot) |
on Jul 19, 2002 at 18:03 UTC ( [id://183346]=note: print w/replies, xml ) | Need Help?? |
Greetings andrew, You really, really don't want to do it that way. Your database will be extremely not normalized. However, if you insist: SELECT name FROM category WHERE name NOT LIKE '%|%'Essentually, you're selecting all category names that don't have a pipe in them. However, like I said, you really should seperate the categories into single items that reference each other with ids. -gryphon
In Section
Seekers of Perl Wisdom
|
|