Help - select syntax if else

;noimage" so then is possible to optimise my database otherwise I need to do this with web development scripts to check if I have image name like in image field so its sucks so maybe somebody can help me with that ok Mega Regards -- Svens Klave

jus a question about tables

So I have question. is it ok if I put all data in one table by days (by date) in resul I will have lot of rows day 20021025 - 45000 rows day 20021026 - 23445 rows day 20021027 - 389023 rows day 20021028 - 78632 rows total = 536100 rows of data I count web page hits and hosts by hourly rotat

can anybody tell me!!!

Hello I have server Intel P-4 2,8Ghz 2Gb RAM so and I hve INNODB and table with 145000 records and when Im trying to query select * from bla where date like "20021025%" order by date DESC limit 20 searhc time is 2,4 to 3,2 seconds what a hell is going on? What can I do to fast up these quesry