While others have helped you with your current problem of splitting the column, I'm going to suggest that your future problem will be that you didn't normalize your database and put the favorites in their own related table. It seems highly likely that some day you might want to write a SQL query to find out which favorites link to which sites, or rewrite some URLs in the favorites, and you could do it more easily if favorites were a table. 
-- supposing favorites are attached to user records

CREATE TABLE user_favorites (
  userid integer not null,
  title  varchar(100) not null,
  link   varchar(255) not null,
  num    integer not null,
  PRIMARY KEY (userid, title),
  FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE
);

[download]

Or, even if you hate the idea of a second table, you could store favorites as JSON and on most modern databases you can also reach into that with SQL.

In reply to Re: Limit loop by NERDVANA
in thread Limit loop by htmanning

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.