I want to find all the names 'banana' but with a case INsensitive search so I want that 'banana','Banana','bAnana' and so on are treated the same.
So .. a quick test shows/tell that for example
Code: Select all
SELECT name from users where name = 'banana'
But so also
Code: Select all
SELECT name from users where name LIKE 'banana'
So .. 'what's the best way' for this search ? Skipping white spaces would be also nice I mean I'd like if ' banana' and/or 'banana ' or ' banana ' would be treated the same.
I just don't get exactly 'what's LIKE for compared to =' ?




