[SQL] substr_count

2003-07-09 Thread Tom Rochester
Hey all, I would like to achive something along the lines of: SELECT field FROM table WHERE field ILIKE '$searchterm' ORDER BY substr_count(field, '$searchterm'); Of course the substr_count function does not exist. Is there anyway to do this? I had a thought char_count(replace(field, !$search

Re: [SQL] substr_count

2003-07-11 Thread Rajesh Kumar Mallah
On Thursday 10 Jul 2003 10:08 am, Tom Rochester wrote: > Hey all, > > I would like to achive something along the lines of: > > SELECT field FROM table WHERE field ILIKE '$searchterm' ORDER BY > substr_count(field, '$searchterm'); > Hi In case you are attempting to search text in a feild and sor