Hi all,
I am writing a query to fetch records based on some condition. Instead of putting a where clause can I put a concat operation for the condition and join them and execute as a single condition ?
Which is the more efficient one ?
E.g.
Instead of using
select * from table name where column1 ='21'
and column2 = '
TEST'
can I use
select * from table name where concat(concat(column1, ' '),column2)='21 TEST')
I would also like to know how the DB will execute this query internally.