Solved

search

Posted on 2000-04-08
2
166 Views
Last Modified: 2010-03-05
hi experts,

I am writing a search engine for my database. i am using MySQL, and using Perl dbi.
how can i write SQL statement so that it will check each field for the string?

i only know to check only one field like:
select * from table_name where name=$search_string

but i want to check not only the name field, but all the fields in that table.
thanks.

Stanley
0
Comment
Question by:stanleyhuen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 2

Accepted Solution

by:
tpryor earned 20 total points
ID: 2697842
well if the data is all in the same table
you need to append to your where clause.

like so...

select * from table_name where name=$search_string || field_name2=$search_string || field_name3=$search_string etc...

if the data is across multible tables
you must prefix the table name using dot notation to the field name

select * from table_name where name=$search_string || table_name.field_name2=$search_string || table_name.field_name3=$search_string etc...


You could keep this information ( the table and field names ) in arrays for eassier management and execution of the querries.

gl
t
0
 

Author Comment

by:stanleyhuen
ID: 2700837
how can I  keep the information ( the table and field names ) in arrays for eassier management and execution of the querries?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can Oracle Client 11.2.0.2.0 work with an Oracle 12c Database? 5 181
stftime format 4 58
Bash one liner, start and end time calculation 13 124
create a gui in perl 3 110
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question