Code: Select all
SELECT *,
CONCAT(contact.FirstName,contact.LastName,contact.Phone) AS Uniq
FROM `contacts` contact
WHERE Uniq = 'MyFirstnameMyLastname101-10101-101'Moderator: General Moderators
Code: Select all
SELECT *,
CONCAT(contact.FirstName,contact.LastName,contact.Phone) AS Uniq
FROM `contacts` contact
WHERE Uniq = 'MyFirstnameMyLastname101-10101-101'Code: Select all
SELECT *, CONCAT(contact.FirstName,contact.LastName,contact.Phone) AS Uniq
FROM `contacts` contact
WHERE CONCAT(contact.FirstName,contact.LastName,contact.Phone) = 'MyFirstnameMyLastname101-10101-101'