Mysql like query search : I am working on crud functionality in php and mysql for user table.I have keep user status "a" and "d" for "active" and "deactive" respectivaly in database .My problem is when user search on frontend lets say "active" then how I can query to fetch all active status record.Please help..

