Home : General : Databases and SQL :

General: Databases and SQL: 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
Mysql - query - sorting by field, but I want only certain values in that field
Hi All

I would like to create an SQL Dump that displays all the records having a certain field value.

Right now, my query string shows all the records, sorted by the field.

Quote:
SELECT * FROM csup_tickets ORDER BY subject LIMIT 0, 2000

What I want is to be able to display all of the records that have a value of "fred" in the subject field.

subject "fred"

How can I modify the above query string to pull out only the subject "fred" records?

Many thanks Smile

------------------------------------------

Last edited by:

DogTags: Apr 11, 2002, 5:30 AM

Edit Log: