Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

if i have a word and i want to see if it exist in a sentence how can i do that?

if i have a word and i want to see if it exist in a sentence how can i do that?
lets say i want to search for the word "hall" in the sentence "the hall of fame in expert"
and please i dont want it using explode because i know how to do it using explode
0
mgtm3
Asked:
mgtm3
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you explain why you don't want to use explode?
that will clarify in which direction any suggestions have to go.
0
 
mgtm3Author Commented:
beacuse i need something fast
i have a table that have 500,000 rows so i want to search in every row to find something(word)
and using explode i takes me 30-60 seconds to find it.
so becouse of that i want something better and faster
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>i have a table that have 500,000 rows
mysql? did you check out full-text index?
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
lorenzodalcolCommented:
if you use mysql you can use fulltext search.

With PHP you can use strpos

<?php
$mystring = 'the hall of fame in expert';
$findme   = 'hall';
$pos = strpos($mystring, $findme);
 
// Note our use of ===.  Simply == would not work as expected
// because the position of 'a' was the 0th (first) character.
if ($pos === false) {
    echo "The string '$findme' was not found in the string '$mystring'";
} else {
    echo "The string '$findme' was found in the string '$mystring'";
    echo " and exists at position $pos";
}
?>

Open in new window

0
 
mgtm3Author Commented:
angell can you give me an example ?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, in the link I gave you there are plenty of examples...
http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html
mysql> CREATE TABLE articles (
    ->   id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
    ->   title VARCHAR(200),
    ->   body TEXT,
    ->   FULLTEXT (title,body)
    -> );
Query OK, 0 rows affected (0.00 sec)
 
mysql> INSERT INTO articles (title,body) VALUES
    -> ('MySQL Tutorial','DBMS stands for DataBase ...'),
    -> ('How To Use MySQL Well','After you went through a ...'),
    -> ('Optimizing MySQL','In this tutorial we will show ...'),
    -> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
    -> ('MySQL vs. YourSQL','In the following database comparison ...'),
    -> ('MySQL Security','When configured properly, MySQL ...');
Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0
 
mysql> SELECT * FROM articles
    -> WHERE MATCH (title,body) AGAINST ('database');
+----+-------------------+------------------------------------------+
| id | title             | body                                     |
+----+-------------------+------------------------------------------+
|  5 | MySQL vs. YourSQL | In the following database comparison ... |
|  1 | MySQL Tutorial    | DBMS stands for DataBase ...             |
+----+-------------------+------------------------------------------+
2 rows in set (0.00 sec)

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now