Trying to do an advanced search with MySQLi Server Behavior
I am doing a test website before I decide if I am going to continue to use your WebAssist MySQLi Server Behaviors product. I want to be able to search my dvd library to decide what we are going to watch. I have a database with the name, genre, rating, length, etc. I want to be able to type into a for "Comedy" and have it bring up all movies with "Comedy" in the genre even though the actual genre might be "Romantic Comedy" Then I would like to be able to select a year of release such as "Newer than 2010" I can find the "=" statement in the query but I can't make it do a "LIKE" query, "greater than", etc. Also sometimes it's nice to go, Oh yeah, I remember one called something like "Hobbit" and be able to bring up all the movies with "Hobbit" in the title. Let me know if this is an available feature that I just can't see or if I need to request a refund. Actually I may as well request a refund now because I looked pretty hard already.