Simple search in Sybase

A simple search is what you want when you know exactly the data you are looking for and you know which column and table it is in.

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

Type
```
        select
```
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
```
If you want every column to be returned, type an asterisk.
Type
```
        from
```
Type the name of the table you are searching.
Type
```
        where
```
Type the name of the column you are searching.
Type
```
        =
```
Type
```
        "
```
Type the word(s) you are searching for.
Type
```
        "
```
Type
```
        go
```
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 John Jones in a table called rolodex and return all the columns, type

        select * from rolodex where name=John Jones
        go

Next: Sybase searches when you know part of the data
See also: Searching Sybase databases
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Computer Center: Help System
TCC 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/24 23:54:43 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/simple_search.html