[PHP-DB] REGEXP problem

2002-06-14 Thread Martin Adler
sorry, a bug of my e-mailclient quotes some charaters now without slashes ;-) # Hi, I working with this query SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP "\\."+category.id+"(\\.|$)" LEFT JOIN entgroup ON entries.id = entgroup.eid LEFT JOIN c

[PHP-DB] REGEXP problem

2002-06-14 Thread martin . adler
Hi, I working with this query SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP \".\"+category.id+\"(.|$)\" LEFT JOIN entgroup ON entries.id = entgroup.eid LEFT JOIN catgroup ON category.id = catgroup.cid LEFT JOIN mzgroup ON mzgroup.id = entgroup.gid || catgroup.gid W