Search for Wild Card in SQL

I came across multiple queries that use this when the condition is:

select ...
where Name like '%'


Does it make sense to use a wildcard?


source to share

2 answers


is equivalent WHERE Name IS NOT NULL

(at least in the tests I ran). The later version is arguably more efficient and IMO much easier to see the intent, but I suppose it like '%'

saves a few keystrokes. Either way, it's not just filler.



Probably not, I have some kind of edge case that I am not aware of with how text search is handled. I would do an experiment to see what it does if Name is null if I'm near a MySQL client right now.

I've seen some code that uses queries with "... where 1 = 1" just because it was easier to output a nonsensical where clause than to deal with cases where the where clause is missing from the generated queries. Or I used to be a meaningful condition that has been removed in some editions.



All Articles