Hi,

I am trying to fetch the records ending within this week...so I made a query string this.....

select * from bcc join business b on bcc.bizbcc_biz_id = b.biz_id join city c on bcc.bizbcc_city_id = c.city_id where bizbcc_enddate regexp '.*[05]\/.*' and bizbcc_enddate regexp '.*\/[13-7]\.*' and bizbcc_enddate regexp '.\/*2010.*'

But its not giving relevant results....

Any expert comments would be appreciated.

What're the field types?

varchar

what is varchar?

Originally Posted by dressupgames8

what is varchar?

varchar is a variable length character field (strings)

the short answer is:
a sting stored in a 'char' field will be padded with spaces to the size of the field, whereas with a 'varchar' field it will be stored almost "as is" (minus any trailing spaces).

The long explanation is:
http://dev.mysql.com/doc/refman/5.0/en/char.html

AND This question is a perfect example of why dates should always be stored as date fields