Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Sybase searches for multiple columns

Tech Computer Center logo

If you want to search for items in multiple columns (for instance, all the Johns in Seattle in a rolodex) this is the way to do it.

At the end of each command press the space-bar or press enter before continuing the next step.

  1. Type
            select
  2. Type the name of the columns you displayed after the search. Separate each column name with a comma. For instance, if you are searching for John Jones and you want to know his phone number and his address, so you would type
            phone, address
  3. If you want every column to be returned, type an asterisk.
  4. Type
            from
  5. Type the name of the table you are searching.
  6. Type
            where
  7. Type the name of the column you are searching.
  8. Type
            like
  9. Type
            "
  10. Type the word(s) for the first item you are searching for, including any wildcards you need (see `Sybase searches when you know part of the data' for more about wildcards).
  11. Type
            "
  12. Type
            and
  13. Type the name of the column you are searching.
  14. Type
            like
  15. Type
            "
  16. Type the word(s) you the first item you are searching for, including any wildcards you need.
  17. Type
            "
  18. If you need to add any more columns, repeat the "and column_name like data" group.
  19. Type
            go
  20. Press Enter.

If there is a value that matches your search, you see the results from your search and

        (1 row affected)
The number may be 2 or 3, or larger if your search matches more than one row.

For example, to find all the Johns in Seattle in a table called rolodex and return all the columns, type

        select * from rolodex where name like John%
            and city=Seattle go

Next: Sybase: computing values from search results
See also: Searching Sybase databases
Previous: Sybase searches when you know part of the data
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/25 20:21:06 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/search_mult_cols.html
QR two-dimensional bar code