How do I make a query where I use a wildcard...?
I think I read once it can be done like this: WHERE name ~* 'Something'...
but does the LIKE and 'something%' work together...
With thanks in advance, Arni
you are thinking of PERL, not SQL. PERL: if($name=~/regexp/)
LIKE is a proper wildcard in SQL.
If you are not sure, why not check the manual?
Ok, thanks, you're the best 🙂
Not the best, just the only person on here during the american nighttime :-)
If I wanna use LIKE everwhere... It doesn't slow down the execution time? ... Instead of where name = 'this' just use WHERE name like ''? 🙂
Excuse the rambling if you don't understand...
Don't use LIKE everywhere. "LIKE" is much more expensive than "=", so if you want to do an exact match, always use "="
