in reply to MySQL Answer

SELECT * FROM table WHERE title LIKE "category1|subcat1|%" ORDER BY title;

Replies are listed 'Best First'.
Re: Re: MySQL Answer
by Anonymous Monk on Jul 19, 2002 at 13:28 UTC
    Thank you, I was thinking of that
[reply]
      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