> I would like a single row in a table, and not more than one, to be
> used as a preferred value in another application.
> Is this possible, and, if yes, how?
add a column 'preferred', tinyint(1) NOT NULL.
To change the preferred value:
UPDATE table SET preferred=0
UPDATE table SET preferred=1 WHERE column_id=1234
Freelance web developer
If you find my advice useful, please consider donating to a poor
student! You can choose whatever amount you think my advice was
worth to you. http://tinyurl.com/7oa5s