I want to do the following select
is an other way to handle it?Code:select sure_name, english_name from student2 where sure_name like
'test%'
union all
select sure_name, english_name from student2 where english_name like
'test%'
Thank you
Printable View
I want to do the following select
is an other way to handle it?Code:select sure_name, english_name from student2 where sure_name like
'test%'
union all
select sure_name, english_name from student2 where english_name like
'test%'
Thank you
Here is another way to do the same:
select sure_name, english_name from student2 where sure_name like 'test%' OR english_name like 'test%'