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
code('Perl') || die;
|