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

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

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

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