You can use the exists filter combined with a bool/must filter like this: { “query”: { “filtered”: { “filter”: { “bool”: { “must”: [ { “exists”: { “field”: “price” } }, … <– your other constraints, if any ] } } } } } DEPRECATED (since ES5) You can also use the missing filter combined … Read more
if ($(“.element1”).is(‘*’) || $(“.element2”).is(‘*’)) { // code } EDIT (per comment) Select elements by multiple classes in one call: if ($(“.element1, .element2”).is(‘*’)) { // code }
You cannot do this with a simple SQL statement. A SQL query will not compile unless all table and column references in the table exist. You can do this with dynamic SQL if the “subquery” is a table reference or a view. In dynamic SQL, you would do something like: declare @sql nvarchar(max) = ‘ … Read more
There are two relevant functions on POSIX systems: stat() and lstat(). These are used to find out whether a pathname refers to an actual object that you have permission to access, and if so, the data returned tells you what type of object it is. The difference between stat() and lstat() is that if the … Read more
Simpler, shorter, faster: EXISTS. IF EXISTS (SELECT FROM people p WHERE p.person_id = my_person_id) THEN — do something END IF; The query planner can stop at the first row found – as opposed to count(), which scans all (qualifying) rows regardless. Makes a big difference with big tables. The difference is small for a condition … Read more
EDIT I want to add the reason that your IF statement seems to not work. When you do an EXISTS on an aggregate, it’s always going to be true. It returns a value even if the ID doesn’t exist. Sure, it’s NULL, but its returning it. Instead, do this: if exists(select 1 from table where … Read more
The following solution is a bit simpler: from sqlalchemy.sql import exists print session.query(exists().where(User.email == ‘…’)).scalar()
The standard File module has the usual file tests available: RUBY_VERSION # => “1.9.2” bashrc = ENV[‘HOME’] + ‘/.bashrc’ File.exist?(bashrc) # => true File.file?(bashrc) # => true File.directory?(bashrc) # => false You should be able to find what you want there. OP: “Thanks but I need all three true or false” Obviously not. Ok, try … Read more
Use CASE: SELECT TABLE1.Id, CASE WHEN EXISTS (SELECT Id FROM TABLE2 WHERE TABLE2.ID = TABLE1.ID) THEN ‘TRUE’ ELSE ‘FALSE’ END AS NewFiled FROM TABLE1 If TABLE2.ID is Unique or a Primary Key, you could also use this: SELECT TABLE1.Id, CASE WHEN TABLE2.ID IS NOT NULL THEN ‘TRUE’ ELSE ‘FALSE’ END AS NewFiled FROM TABLE1 LEFT … Read more
Create a UNIQUE constraint on your subs_email column, if one does not already exist: ALTER TABLE subs ADD UNIQUE (subs_email) Use INSERT … ON DUPLICATE KEY UPDATE: INSERT INTO subs (subs_name, subs_email, subs_birthday) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE subs_name = VALUES(subs_name), subs_birthday = VALUES(subs_birthday) You can use the VALUES(col_name) function in the … Read more