Tag Info

New answers tagged


something like this should be enough: select * from employee_table where Length(lastname) - length(replace(lastname, 'n','')) = 2 be aware that may cause a full table scan :-)


This is a known issue when using SQL Server 2008 to search for a number with more than nine digits. When using certain word-breakers, the number is stored in its scientific form e.g. nn5d68952e+009, leading to false-positive matches. One of the word-breakers affected is the neutral language (lcid 0): -- Result includes nn5d68952e+009 SELECT display_term ...


How would I guarantee to the user that no matter how he types "chair" (singular, plural, with or without adjectives), he will get all the results that the database can provide? Wildcard queries could solve your immediate problem. For example, your products table may have the following entries: productID companyID productType ...


Since the content of 'Keywords' is interpreted by the RDBMS instead of being read literally, your code is vulnerable to SQL Injection . This is also why you get the syntax errors. You must sanitize the content of 'Keywords'. There's an answer on Stack Overflow : here.


You could do the Regex in SPARQL as you suggested, performance implications will vary on the subset of items at the moment it is fired. An example from a SPARQL query using that approach ("Look for all teams in the second league of the bundesliga"): SELECT distinct ?team ?label WHERE { ?team dbp-ont:league ?league . ?league rdfs:label ?league_label ...


you should use a levenshtein function (not a default mysql funcion) as second orderby: SELECT * FROM table WHERE MATCH("doobdy institute") AGAINST (name) ORDER BY MATCH("doobdy institute") AGAINST (name) DESC, levenshtein("doobdy institute", tag) ASC this is a valid implementation of levenshtein algoritm in mysql: ...

Top 50 recent answers are included