the example might be too simple this one is wrong:
Code:
select `ordermain`.`hiddenkey`, `ordermain`.`ordertype`,
`ordermain`.`ordernumber`, `ordermain`.`customerpo`,
`ordermain`.`internalduedatetime`, `ordermain`.`orderstatus`,
`ordermain`.`company`, `ordermain`.`orderdate`, `ordermain`.`employeeid`,
`ordermain`.`nextaction`, `ordermain`.`potentialrepeatfrequency`,
`ordermain`.`potentialinternalcomments`, `ordermain`.`potentialrepeatdate`,
`ordermain`.`totalcapprice`, `ordermain`.`totaldecorationprice`,
`ordermain`.`totalprice`, `employees`.`firstname`, `employees`.`lastname`,
`ordermain_vendors`.`vendornumber`, `list_vendors_domestic`.`name` from
`ordermain` join `employees` on `ordermain`.`employeeid` =
`employees`.`username` left outer join `ordermain_vendors` on
(`ordermain`.`hiddenkey` = `ordermain_vendors`.`hiddenkey` and
`ordermain_vendors`.`vendortype` = 'digitize') left outer join
`list_vendors_domestic` on `ordermain_vendors`.`vendornumber` =
`list_vendors_domestic`.`id` where (`ordermain`.`orderstatus` = 'Order
Completed' and ((`ordermain`.`hiddenkey` like concat('%', '6444', '%') escape
'!' and (`ordermain`.`hiddenkey` like concat('%', '6444', '%') escape '!' or
`ordermain`.`ordertype` like concat('%', '6444', '%') escape '!' or
`ordermain`.`contactname` like concat('%', '6444', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', '6444', '%') escape '!' or
`ordermain`.`phone` like concat('%', '6444', '%') escape '!' or
`ordermain`.`company` like concat('%', '6444', '%') escape '!' or
`ordermain`.`email` like concat('%', '6444', '%') escape '!' or
`ordermain`.`fax` like concat('%', '6444', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', '6444', '%') escape '!' or
`employees`.`firstname` like concat('%', '6444', '%') escape '!' or
`employees`.`lastname` like concat('%', '6444', '%') escape '!' or
`employees`.`email` like concat('%', '6444', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', '6444', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', '6444', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', '6444', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', '6444', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', '6444', '%') escape '!') and
(`ordermain`.`hiddenkey` like concat('%', 'null', '%') escape '!' or
`ordermain`.`ordertype` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`contactname` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', 'null', '%') escape '!' or
`ordermain`.`phone` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`company` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`email` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`fax` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', 'cat', '%') escape '!' or
`employees`.`firstname` like concat('%', 'cat', '%') escape '!' or
`employees`.`lastname` like concat('%', 'cat', '%') escape '!' or
`employees`.`email` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', 'cat', '%') escape '!') and
(`ordermain`.`hiddenkey` like concat('%', 'null', '%') escape '!' or
`ordermain`.`ordertype` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`contactname` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', 'null', '%') escape '!' or
`ordermain`.`phone` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`company` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`email` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`fax` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', 'dog', '%') escape '!' or
`employees`.`firstname` like concat('%', 'dog', '%') escape '!' or
`employees`.`lastname` like concat('%', 'dog', '%') escape '!' or
`employees`.`email` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', 'dog', '%') escape '!')) or
`ordermain`.`hiddenkey` = 35985 or `ordermain`.`hiddenkey` = 56190))
I want it like:
Code:
select `ordermain`.`hiddenkey`, `ordermain`.`ordertype`,
`ordermain`.`ordernumber`, `ordermain`.`customerpo`,
`ordermain`.`internalduedatetime`, `ordermain`.`orderstatus`,
`ordermain`.`company`, `ordermain`.`orderdate`, `ordermain`.`employeeid`,
`ordermain`.`nextaction`, `ordermain`.`potentialrepeatfrequency`,
`ordermain`.`potentialinternalcomments`, `ordermain`.`potentialrepeatdate`,
`ordermain`.`totalcapprice`, `ordermain`.`totaldecorationprice`,
`ordermain`.`totalprice`, `employees`.`firstname`, `employees`.`lastname`,
`ordermain_vendors`.`vendornumber`, `list_vendors_domestic`.`name` from
`ordermain` join `employees` on `ordermain`.`employeeid` =
`employees`.`username` left outer join `ordermain_vendors` on
(`ordermain`.`hiddenkey` = `ordermain_vendors`.`hiddenkey` and
`ordermain_vendors`.`vendortype` = 'digitize') left outer join
`list_vendors_domestic` on `ordermain_vendors`.`vendornumber` =
`list_vendors_domestic`.`id` where (`ordermain`.`orderstatus` = 'Order
Completed' and (( (`ordermain`.`hiddenkey` like concat('%', '6444', '%')
escape '!' or `ordermain`.`ordertype` like concat('%', '6444', '%') escape '!'
or `ordermain`.`contactname` like concat('%', '6444', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', '6444', '%') escape '!' or
`ordermain`.`phone` like concat('%', '6444', '%') escape '!' or
`ordermain`.`company` like concat('%', '6444', '%') escape '!' or
`ordermain`.`email` like concat('%', '6444', '%') escape '!' or
`ordermain`.`fax` like concat('%', '6444', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', '6444', '%') escape '!' or
`employees`.`firstname` like concat('%', '6444', '%') escape '!' or
`employees`.`lastname` like concat('%', '6444', '%') escape '!' or
`employees`.`email` like concat('%', '6444', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', '6444', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', '6444', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', '6444', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', '6444', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', '6444', '%') escape '!') and
(`ordermain`.`hiddenkey` like concat('%', 'null', '%') escape '!' or
`ordermain`.`ordertype` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`contactname` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', 'null', '%') escape '!' or
`ordermain`.`phone` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`company` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`email` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`fax` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', 'cat', '%') escape '!' or
`employees`.`firstname` like concat('%', 'cat', '%') escape '!' or
`employees`.`lastname` like concat('%', 'cat', '%') escape '!' or
`employees`.`email` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', 'cat', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', 'cat', '%') escape '!') and
(`ordermain`.`hiddenkey` like concat('%', 'null', '%') escape '!' or
`ordermain`.`ordertype` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`contactname` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`eclipseaccountnumber` like concat('%', 'null', '%') escape '!' or
`ordermain`.`phone` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`company` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`email` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`fax` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`employeeid` like concat('%', 'dog', '%') escape '!' or
`employees`.`firstname` like concat('%', 'dog', '%') escape '!' or
`employees`.`lastname` like concat('%', 'dog', '%') escape '!' or
`employees`.`email` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`ordernumber` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`customerpo` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`nextaction` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`searchtags` like concat('%', 'dog', '%') escape '!' or
`ordermain`.`orderstatus` like concat('%', 'dog', '%') escape '!')) or
`ordermain`.`hiddenkey` = 35985 or `ordermain`.`hiddenkey` = 56190))
