Quote from neodude2 on October 9, 2020, 2:58 am

You shouldn't repeat WHERE. :)

SELECT * from userinfos WHERE email like '%searchemailhere%' AND site like '%searchsitehere%'

Quote from Gaev on October 9, 2020, 3:22 am

@cdy44-2

Search in table "userinfos" in column "email" AND in column "site"

You do not say what content (values) in columns "email" and "site", that you want to be searched e.g. ... everyone at gmail.com or websites ending in .es etc.

SELECT * from userinfos

... this is fine

WHERE email like 'blahblahlah' AND WHERE site like 'more blah'

... should be something like ...

WHERE email like 'blahblahblah' AND WHERE site like 'more blah'

... see https://www.w3schools.com/sql/sql_and_or.asp for more details

For detailed use of LIKE patterns, see ...

https://www.w3schools.com/sql/sql_like.asp
and
https://www.w3schools.com/sql/sql_wildcards.asp

... if you have difficulty understanding the special pattern characters, tell us what content you would like to match.

Quote from CDY@44 on October 9, 2020, 4:06 pm

Thank you Neodude2 and Gaev !

Yes ( WHERE email like 'blahblahlah' AND  site like 'more blah' ) that what I wanted to do.

Thank you for the links. There are a lot of interesting things to learn about SQL

Best regards,