Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
CONTAINS |
Sat, Feb 1 2014 10:33 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I'd like to be able to use expressions such as
(_UserFlags CONTAINS 'One') as part of the SELECT clause and not just be restricted to the WHERE clause Roy Lambert |
Sun, Feb 2 2014 4:56 PM | Permanent Link |
Barry | Roy,
+1 I suspect there isn't a Contains function because the Contains in the where clause examines the indexes and not the actual field values. MySQL has a really nice feature in that it can rank the rows that met the full text search criteria. See https://dev.mysql.com/doc/internals/en/full-text-search.html So a higher ranking meant the row met more of the search criteria. You can do a workaround and write your own Contains() function. Either pass each search word as a separate parameter or use a comma delimited string of search words. My Parse() and PosExx() functions may help you in this regard. Barry |
Mon, Feb 3 2014 3:52 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Barry
>You can do a workaround and write your own Contains() function. I already have - TEXTSEARCH - written because CONTAINS only works on full text indexed columns. Its in extensions Roy |
Mon, Feb 3 2014 7:39 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I'd like to be able to use expressions such as (_UserFlags CONTAINS 'One') as part of the SELECT clause and not just be restricted to the WHERE clause >> Hmm, I'll see what I can do. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |