I have a Mysql database that I want to take certain entries off line if I find the data outdated. I have added a column to the data table that I want to use to indicate this dataentry is offline (Y/N). Can any one either show me how, or point me to information on how to read this entry in this table and know to ingore this data when searching.

Thanks,
Richard

It depends, but as usual it is difficult to suggest anything without having details about the table structure and other information.

The simplest suggestion I can offer is for you to add a HAVING condition appended to your original SQL query. This way you probably don't need to worry about adding an index for this new column.

An example follows:


Something like that...

__________________
Custom BB codes you can use here:
[HTML] | [C++] | [CSS] | [JAVA] | [PY] | [VB]

Even though I ony gave a little information, you were able to pull it out in the end.


Thanks, your suggestion works just fine.

Again,

Thanks,
Richard