Hmm. You might be able to hack this up using the if() function, but it's not
gonna be a beauty to look at, and possibly not terribly performant, either.
You may need to look at external data query tools - I think a number of
fulltext search tools provide match percentages in their results.
On Th
You regular expression is alittle off. You don't need the OR operator
'|' inside the character class definition, it is implied. Try this:
[php]
SELECT * FROM tbl where Fname REGEXP '^[abcd]'
[/php]
- michael dykman
On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar
wrote:
> Hi ,
>
> Am just try
Hi ,
Am just trying alphabetical pagination ,
Yes there is lot of pager class there for this ,
but in my requirement little but diff , that is
totally 4 sets ,
A-DE-H I-PQ-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name starting
Hi All,
I have a table with different fileds and almost the type of all them are
smallint. I want to search on some fields with "OR" condition. I want to know
is
there possibility to know how many fileds matched exactly? then I can say how
many percent match are available.
select * from my_ta
Hi,
The mathematical way to add two "partial" harmonic means to generate new
harmonic mean is:
Let X1 , X2 be two harmonic means on different rollup rows, generated using
n1 and n2 # of facts respectively.
The combined harmonic mean would be:
(n1 + n2)/( n1/x1 + n2/x2)
If you have experience w
On 10/19/2010 12:38 PM, Montgomery, Tammie wrote:
I had an old version of mySQL on my computer but never used it. I thought I
knew the root password but it wouldn't let me in. I went ahead and uninstalled
it thinking I would get a newer version anyway. I used the Windows interface to
uninstall
