473,395 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

search with AND boolean operator

10
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
Jun 13 '07 #1
4 1518
Motoma
3,237 Expert 2GB
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
You are on the right track Raphaelle. You will need to perform a level of parsing on the data you receive from the user. Am I correct in assuming you are using MySQL, or are you doing a search on something else?
Jun 13 '07 #2
shoonya
161 100+
nope dude
you have to explode it
eg
Expand|Select|Wrap|Line Numbers
  1. developer = abc and priority = high
is the query
Expand|Select|Wrap|Line Numbers
  1. select ** from *** where developer = abc INTERSECT select ** from **** where priority = high
Jun 14 '07 #3
pbmods
5,821 Expert 4TB
MySQL also supports boolean operators in fulltext searches.
Jun 14 '07 #4
ak1dnar
1,584 Expert 1GB
Hi!
I am doing a search engine and I would like to make a search with the operator AND possible but I canīt find out how. Do I have to explode the phrase entered after each and" or does it exist an easier way to do that?
Thanks for your help
Raphaelle
Have you solved this problem yet? could you please provide more details that describe how your user inputs looks like for the search criteria.
I think you are using a textbox input isn't it?.
Jun 17 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: dave | last post by:
I am wondering if the following can be done. I want to setup a search page that utilizes full text searching in sql2000. I want the user to type in say "where is bill" and have the query search...
1
by: Les Juby | last post by:
A year or two back I needed a search script to scan thru HTML files on a client site. Usual sorta thing. A quick search turned up a neat script that provided great search results. It was fast,...
39
by: Noticedtrends | last post by:
Can inference search-engines narrow-down the number of often irrelevant results, by using specific keywords; for the purpose of discerning emerging social & business trends? For example, if...
16
by: Shawnk | last post by:
I would like to perform various boolean operations on bitmapped (FlagsAttribute) enum types for a state machine design as in; ------------------- enum portState { Unknown, Open,
5
by: justobservant | last post by:
When more than one keyword is typed into a search-query, most of the search-results displayed indicate specified keywords scattered throughout an entire website of content i.e., this is shown as...
1
by: Eric | last post by:
Hi: I have two files. I search pattern ":" from emails text file and save email contents into a database. Another search pattern " field is blank. Please try again.", vbExclamation + vbOKOnly...
4
by: BenCoo | last post by:
Hello, In a Binary Search Tree I get the error : Object must be of type String if I run the form only with the "Dim bstLidnummer As New BinarySearchTree" it works fine. Thanks for any...
3
by: kenny rullo | last post by:
Hello people, I'm a new member of this fantastic community! I'm a student and i have to solve this puzzle: I have a string like "The quick brown fox jumps over the lazy dog" (or longer) I...
3
nathj
by: nathj | last post by:
Hi, I am just trying to develop a search system for my website. The PHP side of things is no trouble at all. I have also set up what I think are appropriate FULLTEXT indices on the tables I will...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.