in reply to Re: Pulling out information for MySQL
in thread Pulling out information for MySQL
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;
|
|---|