CONTACT() AS something - something in WHERE clause
Posted: Fri Jan 06, 2006 11:34 am
Any way to get this work in MySQL 4.0.x?
Thanks
Code: Select all
SELECT *,
CONCAT(contact.FirstName,contact.LastName,contact.Phone) AS Uniq
FROM `contacts` contact
WHERE Uniq = 'MyFirstnameMyLastname101-10101-101'