Gossamer Forum: General: Databases and SQL: Re: [DogTags] Mysql - query - sorting by field, but I want only certain values in that field: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Re: [DogTags] Mysql - query - sorting by field, but I want only certain values in that field: Edit Log

Here is the list of edits for this post

Apr 11, 2002, 6:47 AM

Wil

Veteran / Moderator (4108 posts)

Apr 11, 2002, 6:47 AM

Re: [DogTags] Mysql - query - sorting by field, but I want only certain values in that field

Code:
SELECT * FROM tickets WHERE (subject LIKE '%fred% OR subject LIKE %dog%') AND (name LIKE '%ethel% OR name LIKE %bone%')  
ORDER BY subject, name LIMIT 0, 2000

- wil

Last edited by:

Wil: Apr 11, 2002, 6:49 AM

Edit Log:

Post edited by Wil Post edited by Wil (Veteran) on Apr 11, 2002, 6:49 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676