Menu
I have a where clause like the below example:
WHERE (subject LIKE 'chef%') AND (dep LIKE 'psy%%')
What is the difference using 1 or 2 percent signs? I know what one means (wild card), but not what the second adds in functionality.
417
The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the LIKE operator: The percent sign (%) represents zero, one, or multiple characters. The underscore sign (_) represents one, single character.
You can specify multiple conditions in a single WHERE clause to, say, retrieve rows based on the values in multiple columns. You can use the AND and OR operators to combine two or more conditions into a compound condition.
Solution: The wildcard in a WHERE clause is useful when an exact match is not possible in a SELECT statement.
The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions.
That query is likely a typo; putting a double % does nothing in the example you have given as there are no non-wildcard characters between the two %'s.
If you wanted to search for an actual % character you can use escaping.
80
Usage of double '%' is mostly for specifying there are no wildcards present between them.however it is also used for using actual '%' in searchquery which is called escaping.
using '%' escaping looks like
SELECT name FROM emp
WHERE id LIKE '%\%%' ESCAPE '\'
for more details on escaping Escaping
41
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
