"mysql ifnull “n/a” yields “item cannot be found in the collection” error" Code Answer

2

your query is good, but your code is probably looking for a column name? try an alias:

select ifnull(mem.address2,'n/a') as address2 from members mem ...
By Ivan Gavrilovic on June 17 2022

Answers related to “mysql ifnull “n/a” yields “item cannot be found in the collection” error”

Only authorized users can answer the Search term. Please sign in first, or register a free account.