in reply to Re: MySQL Answer
in thread MySQL Answer

Thank you, I was thinking of that

Replies are listed 'Best First'.
Re: Re: Re: MySQL Answer
by Anonymous Monk on Jul 19, 2002 at 13:29 UTC
    what if I just wanted to get the 2 categories
[reply]
      select * from table where title regexp "^[^|]*|[^|]*$";

      T I M T O W T D I
[reply]
[d/l]
      SELECT * FROM table WHERE title LIKE "category1|subcat1|%" ORDER BY title LIMIT 2;
[reply]

In Section Seekers of Perl Wisdom