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.
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
------------------------------------------
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, 2000What 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
------------------------------------------
Mysql - query - sorting by field, but I want only certain values in that field