Combine two columns in SQL for WHERE clause (sqlite)

Question

Trying to select data from a table whereby the where clause combines two fields to locate the specific data to be fetched. The code below does not work.

Select Email from users where FirstName || ' ' ||  LastName AS Nominative == 'fjpsojp 09809'

Any reason to not compare the first and last name separately like this SELECT Email FROM users WHERE FirstName = 'fjpsojp' AND LastName = '09809'? You could split the full name into parts in Python with something like this full_name.split(). — kjagiello
– kjagiello, Commented Feb 28, 2018 at 20:26
If your queries work when fed directly into SQL, you are probably having a problem with your double and single quotes with Python strings. — Stacking For Heap
– Stacking For Heap, Commented Feb 28, 2018 at 20:29
What do you mean with "does not work"? Is there any error message? — CL.
– CL., Commented Feb 28, 2018 at 20:34

Jorge Gx · Accepted Answer · 2018-02-28 20:50:30Z

3

If the fields Email, FirstName and LastName are in the Users table, then you can do your select like this:

select Email, FirstName || ' ' || LastName as Nominative 
from users 
where FirstName = 'fjpsojp'
and LastName = '09809';

This will give you results with two columns: one for Email, another for Nominative

answered Feb 28, 2018 at 20:50

Jorge Gx

3213 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Combine two columns in SQL for WHERE clause (sqlite)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related