[PHP] Mysql search query ignoring dots
Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've PO.SE. srl and I want to find it if
the user search for: POSE or PO.SE or P.O.S.E. etc.
I googled in the web but I don't find any solution. I don't want to
add a new field with the cleaned version of my string because I would
like to solve with the query and I prefer that the mysql table not
become too big. But if I will not find a different solution, I will
use this escamotage.
I've find a post that is similar but the solution don't seem to solve
my situation.
You can see it at the url:
http://forums.mysql.com/read.php?10,395557,395584#msg-395584
In my case replace(email, '.', '') = replace(theSearchValue, '.', '');
is indifferent and don't change my results.
My query, searching POSE, is:
select aziende.* from aziende where 10 AND
(MATCH(aziende.ragione_sociale) AGAINST('+POSE' IN BOOLEAN MODE) OR
(replace(aziende.ragione_sociale, '.', '') = replace('POSE', '.',
'')) order by aziende.ragione_sociale limit 0, 10
The alternative choice could be REGEXP but I've red that it make my
query slow in a table of millions of records and I don't know how to
exclude dots in the regular expression.
Can anyone help me?
Thanks in advance.
Barbara
--
Barbara Picci
Micro srl
viale Marconi 222, 09131 Cagliari - tel. (+39) 070400240
http://www.microsrl.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP/Javascript Job in Madrid
Hi all, I am Bárbara Vilela and I work at Tuenti in the Human Resources department in Madrid. Tuenti is a social application and our mission is to improve the communication and transmission of information between people who know each other. Already the #6 most-trafficked website in Spain, Tuenti is also one of the fastest-growing Alexa Top 500 sites and one of the largest invite-only websites worldwide. I am writing you because we have job opportunities for PHP/JavaScript Engineers that could be interesting for you. You can find more information about this position here: http://tbe.taleo.net/NA11/ats/careers/requisition.jsp?org=TUENTITECHNOLOGIEScws=1rid=25 If you think you fit for this job please send me an e-mail with your CV and I´ll get in contact with you soon. Thank you very much, Bárbara Vilela Fernandes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: die function
Hi all,
just to give you another solution that I've successfully adopted:
function die_script($errmsg)
{
$sendto = [EMAIL PROTECTED];
$from = [EMAIL PROTECTED];
$subject = FAILED;
$message = CONNECTION FAILED\nTYPE OF ERROR:\n . mysql_error();
$message .=\n\n;
$headers = From: $from\r\n;
mail($sendto, $subject, $message, $headers);
print $errmsg . /body/html;
die;
}
$connessione = mysql_connect (192.168.168.1,user,password) or
die(die_script($errmsg));
mysql_select_db (dbnamei);
Thanks for your help
Regards
Barbara
Barbara Picci wrote:
Hi all,
I have a machine that must insert in cron in a mysql db in another
remote machine.
The problem is that I cannot know if the connection in the first machine
(adsl) go down because no entry in the machine log is generated. I would
like to redirect the die function in a e-mail that say me what happens.
I think the way you want to solve this problem is to create a customized
error handler. Check out this link:
http://php.net/manual/en/function.set-error-handler.php
?php
function email_error_handler($level, $msg, $file, $line) {
switch ($level) {
/** E_ERROR, E_USER_ERROR, etc. */
mail_to_admin($level: $msg in $file on line $line);
}
}
function mail_to_admin($msg) {
/** stuff */
}
?
--
Teach a man to fish...
NEW? | http://www.catb.org/~esr/faqs/smart-questions.html
STFA | http://marc.theaimsgroup.com/?l=php-generalw=2
STFM | http://php.net/manual/en/index.php
STFW | http://www.google.com/search?q=php
LAZY |
http://mycroft.mozdev.org/download.html?name=PHPsubmitform=Find+search+plugins
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename=signature.asc
Attachment converted: Barbara OS9:signature 276.asc (/) (000B65CD)
--
Barbara Picci
Micro srl
viale Marconi 222, 09131 Cagliari - tel. (+39) 070400240
http://www.microsrl.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] die function
Hi all,
I have a machine that must insert in cron in a mysql db in another
remote machine.
The problem is that I cannot know if the connection in the first
machine (adsl) go down because no entry in the machine log is
generated. I would like to redirect the die function in a e-mail that
say me what happens.
I found a script
?php
function die_script($errmsg)
{
print $errmsg . /body/html;
die;
}
?
and I tried to insert a mail() before die function but I cannot call
the function in this way:
or die(Connection failed: . die_script());
But no email is generated.
How can I do?
Thanks
Barbara
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] group queries result
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (variable $num). query2: select from ads where guest='PK' limit $num; now I have to export all results together sorting them. How can I do that? Can anyone help me? Thanks in advance Barbara -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] group queries result
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (variable $num). query2: select from ads where guest='PK' limit $num; now I have to export all results together sorting them. How can I do that? Can anyone help me? Thanks in advance Barbara -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] group queries result
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (variable $num). query2: select from ads where guest='PK' limit $num; now I have to export all results together sorting them. How can I do that? Can anyone help me? Thanks in advance Barbara -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] group queries result
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (variable $num). query2: select from ads where guest='PK' limit $num; now I have to export all results together sorting them. How can I do that? Can anyone help me? Thanks in advance Barbara -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] help with regular expression
Hi all,
I'm trying from much days to solve a problem with a regular expression...
I'm going to be crazy!
I've a script that must strip a string when it find the first word
containing at least 4 characters; it must print the content of the
string before that word, that word, a separator and the rest of the
string.
I've tried with ereg whit this script ([EMAIL PROTECTED] is the separator):
ereg( '^([^ ]{4,})(.*)$', $testo, $matches);
$contents = [EMAIL PROTECTED];
but it is not the right script because if the strin($testo) is the
thing is the script doesn't find nothing and doesn't print. For this
example the right content of $contents must be:
$contents = the [EMAIL PROTECTED];
instead of nothing.
I've tried with thousand of variant of this script but without success.
have you any ideas of the right regular expression?
Thanks in advance.
Bye
Barbara
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Need help
I want to know how I have to install cURL on my apache server. My apache server is running on Windows ME. Thanks for all. Barbara Guillen. Spain
