Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable:
e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my SQL query i want whatever has been entered to be pattern matched to the data stored in the database, would the query possibale be something like this:
SELECT functionme FROM MsgeTble WHERE alternme LIKE "*$srch*"
Im pretty novice in databases :confused:
Please any suggestions would be grateful! Thanks