Results 1 to 2 of 2

Thread: selct from two column like something

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    selct from two column like something

    I want to do the following select
    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%'
    is an other way to handle it?
    Thank you

  2. #2
    Join Date
    Apr 2012
    Posts
    7
    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%'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •