Re: How to edit part of a field?

2005-06-28 Thread W Luke
On 28/06/05, Brian Dunning <[EMAIL PROTECTED]> wrote: > Hi all - > > I have an urgent need to update several million records. There is a > URL stored in a MySQL 'text' field. Many of the records contain > "1234" like this: > > http://www.domain.com?etc=etc&arg=1234&etc=etc > > Any occurence of "

Re: Searching "IN" a comma separated list

2005-06-25 Thread W Luke
On 25/06/05, Mathias <[EMAIL PROTECTED]> wrote: > I then write you this query which should give you the idea, and i think the > solution : > > mysql> select gid,ugid,FIND_IN_SET(gid,ugid) from groups,groupsList > -> where FIND_IN_SET(gid,ugid) > 0; > +--+-+---+

Searching "IN" a comma separated list

2005-06-25 Thread W Luke
Hi, Have struggled with this all day, and didn't know where else to ask. If it's not appropriate to the list, I apologise - and advice or pointers would be brilliant, as my head is now hurting! So here's the situation: 3 tables. f_u_groups f_groups and f_images f_u_groups contains the user's