I'm havng the same issue. Is there a way to query the database using count with a where statement? I need to find a specific value that shows in several columns (within my table) across my database. I need something like:
SELECT (COUNT(col1) + COUNT(col2)) as totalCount FROM tablename
WHERE col1, col2 = 'my value in multiple columns' AND UserID='colname'
I've tried using IN and LIKE/ also AND/OR and I still can't get the sql query to work correctly.