Loading ...
Sorry, an error occurred while loading the content.

Re: [phpXperts] Mysql simple query problem

Expand Messages
  • Tanvir Alam
    Great, simply helped. you owe me one :) Thanks Tanvir ... permitted_uid(varchar)
    Message 1 of 4 , Sep 3, 2008
    • 0 Attachment
      Great, simply helped. you owe me one :)

      Thanks
      Tanvir


      --- In phpexperts@yahoogroups.com, shiplu <shiplu.net@...> wrote:
      >
      > On Wed, Sep 3, 2008 at 2:35 PM, Tanvir Alam <alam_1674@...> wrote:
      >
      > > here is the table, with two fields areas and
      permitted_uid(varchar)
      > >
      > > areas permitted_uid
      > >
      > > area1 2,3,4
      > > area2 3,4,11
      > > area3 5,2,8
      > >
      > > select areas, permitted_uid where permitted_uid rlike
      > '[^0-9]+4[^0-9]+|[^0-9]+4$|^4[^0-9]+|^4$'
      > Just Used a regular expression.
      > May be there is better ways.
      >
      > --
      > A K M Mokaddim
      > http://talk.cmyweb.net
      > http://twitter.com/shiplu
      > Stop Top Posting !!
      >
    Your message has been successfully submitted and would be delivered to recipients shortly.