MySQL - Use an excel cell to define the criteria for Like
Asked By Cherifa Hima on 24-Sep-13 12:13 PM
Hi,
I have locale column in the database where I need to group locales into specific destinations. I need to use in mysql the statement: (where locale like ?) and use excel cell value to input the locale.
Here is one example:
Locales Destination
Bahamas Nassau Bahamas
Bahamas Paradise Bahamas
Bahamas Sun Bahamas
in this case , ? should be Bahamas.
I used locale like ? but microsoft query did not return anything. So I am sure it is related to how I am writing the statement: where locale like?
the cell is a named range : input.
Thanks