concat example

[nohurry]

Can someone give me a simple concat() in a select query for mysql?

I've looked and tried, but just can't get the darn thing to return anything other than an empty set or a blank page.

This is the piece of code I'm working with:

$result=mysql_query
("
SELECT * FROM user_data
WHERE email='[e-mail]'
AND paswd='booger'=concat(\'email\',\'paswd\')
");

echo "$result";

If someone could give me a bit of a push in the right direction I sure would appreciate it.
Thanks in advance 🙂
dnorton

[[deleted]]

SELECT concat(firstname, lastname) as fullname FROM table

SELECT * FROM table WHERE fullname = concat(firstname, lastname);