Sunamena Posted May 6, 2017 Share Posted May 6, 2017 Hello, I want to have something like the WHERE command. A user types something, for example: "peer". I want a WHERE that also includes "Peer" and "PeEr" and "apeer" and "Peert. Is this by any chance possible? Thanks in advance =D Link to comment Share on other sites More sharing options...
dsonesuk Posted May 6, 2017 Share Posted May 6, 2017 You would have to make the column value and the search value the same case (lower() or upper()) So for example your list of column values will be turned into "peer", "perr", "apeer" and "peert. then using WHERE tableColumnName LIKE '%$needle%' with $needle turned into lowercase search string as well, will find 'peer' from anywhere it is found with text strings from column. Link to comment Share on other sites More sharing options...
Sunamena Posted May 8, 2017 Author Share Posted May 8, 2017 Thanks, this works =D it seems that %s% Includes S and s. =D Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now