I'm looking how to match a name field with 2 database columns
Code: Select all
SELECT id FROM username WHERE firstname LIKE %john% OR %smith% OR firstname IN ('john smith') AND lastname LIKE %john% OR %smith% OR lastname IN ('john smith')Thanks for any help.