1.2.9 order filter by name
Posted: Wed Jul 22, 2009 12:26 am
When I try to filter my orders by name, I get the following error:
Error: Unknown column 'o.firstname' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `order` WHERE order_status_id > '0' AND CONCAT(o.firstname, ' ', lastname) LIKE '%tracy%'
Can anyone help?
Error: Unknown column 'o.firstname' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `order` WHERE order_status_id > '0' AND CONCAT(o.firstname, ' ', lastname) LIKE '%tracy%'
Can anyone help?