Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Re: Pulling out information for MySQL

by gryphon (Abbot)
on Jul 19, 2002 at 18:03 UTC ( [id://183346]=note: print w/replies, xml ) Need Help??


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;

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://183346]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others examining the Monastery: (2)
As of 2024-04-24 23:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found