Well if you know the order of your words.. you can use: SELECT `name` FROM `table` WHERE `name` REGEXP ‘Stylus.+2100’ Also you can use: SELECT `name` FROM `table` WHERE `name` LIKE ‘%Stylus%’ AND `name` LIKE ‘%2100%’
Use: SELECT t1.Notes, t2.Name FROM Table1 t1 JOIN Table2 t2 ON t1.Notes LIKE CONCAT(‘%’, t2.Name ,’%’)
To escape special characters in a LIKE expression you prefix them with an escape character. You get to choose which escape char to use with the ESCAPE keyword. (MSDN Ref) For example this escapes the % symbol, using \ as the escape char: select * from table where myfield like ‘%15\% off%’ ESCAPE ‘\’ If … Read more
What you want is: tblCustomerInfo.Info LIKE ‘%’ + @SEARCH + ‘%’ (or edit the parameter value to include the % in the first place). Otherwise, you are either (first sample) searching for the literal “@SEARCH” (not the arg-value), or you are embedding some extra quotes into the query (second sample). In some ways, it might … Read more
You’re able to do database finds using LIKE with this syntax: Model::where(‘column’, ‘LIKE’, ‘%value%’)->get();
Use LIKE BINARY: mysql> SELECT ‘abc’ LIKE ‘ABC’; -> 1 mysql> SELECT ‘abc’ LIKE BINARY ‘ABC’; -> 0
If you do LIKE :code and then do namedQuery.setParameter(“code”, “%” + this.value + “%”); Then value remains free from the ‘%’ sign. If you need to use it somewhere else in the same query simply use another parameter name other than ‘code’ .
Typically you use String.StartsWith/EndsWith/Contains. For example: var portCode = Database.DischargePorts .Where(p => p.PortName.Contains(“BALTIMORE”)) .Single() .PortCode; I don’t know if there’s a way of doing proper regular expressions via LINQ to SQL though. (Note that it really does depend on which provider you’re using – it would be fine in LINQ to Objects; it’s a matter … Read more
You could use the DATEPART() function SELECT * FROM record WHERE (DATEPART(yy, register_date) = 2009 AND DATEPART(mm, register_date) = 10 AND DATEPART(dd, register_date) = 10) I find this way easy to read, as it ignores the time component, and you don’t have to use the next day’s date to restrict your selection. You can go … Read more
From the docs: The $not operator does not support operations with the $regex operator. Instead use // or in your driver interfaces, use your language’s regular expression capability to create regular expression objects. Consider the following example which uses the pattern match expression //: db.inventory.find( { item: { $not: /^p.*/ } } ) EDIT (@idbentley): … Read more