in reply to Re: Re: MySQL Answer
in thread MySQL Answer

what if I just wanted to get the 2 categories

Replies are listed 'Best First'.
Re: Re: Re: Re: MySQL Answer
by Nightblade (Beadle) on Jul 19, 2002 at 13:38 UTC
    SELECT * FROM table WHERE title LIKE "category1|subcat1|%" ORDER BY title LIMIT 2;
[reply]
Re: Re: Re: Re: MySQL Answer
by Cine (Friar) on Jul 19, 2002 at 13:32 UTC
    select * from table where title regexp "^[^|]*|[^|]*$";

    T I M T O W T D I
[reply]
[d/l]

In Section Seekers of Perl Wisdom