Have you tried "explain?" Have you indexed the table?
Curtis
On Sun, 8 Feb 2004, ___bug wrote:
> Hello,
>
>
> What is the best way to search a table with about 500.000 rows of varchar
> type.
> ---
> / id / time / name /
> ---
> Like '%blah%' and x Like '%blu
Greetings...
I am developing an application on MySQL using the MySQL API's.
I have .sql file with 1 insert statement. I want to run all the queries
in one shot. mysql_real_query() allows me to execute only one query at a
time ?
So what do you think is the best approach to execute all the qu
Hi,
You can try with string function substring(),LPAD(),RPAD()...
Please look in documentation at :
"6.3.2 String Functions"
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
> I'd like to find all the records that contains this : "wr??"
>
> That's why I did this query : "SELECT * FROM table WHERE rights LIKE
> 'wr??'"
Try to use this one:
"SELECT * FROM table WHERE rights LIKE 'wr%'" (It means everything that
begins from 'wr')
Next point:
'?' - it is not pa
tristan Israel wrote:
> Hello,
>
> I have a field named "rights" (varchar[9])
>
> it contains some records like "wrxwrxwrx" or "wr-w--w-x"
>
> I'd like to find all the records that contains this : "wr??"
>
> That's why I did this query : "SELECT * FROM table WHERE rights LIKE
> 'wr??'
For measuring relevance, you'll need to come up with our own weights and
algorithms. MySQL doesn't do that kinds of things. For more information,
read the documentation of Google at:
http://citeseer.nj.nec.com/brin98anatomy.html
or http://www7.scu.edu.au/programme/fullpapers/1921/com1921.htm
C
