Solved

search

Posted on 2000-04-08
2
161 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
problem with using the glob function 1 64
use google analytics code in perl script 2 66
Perl Awk Need Help 3 109
File Find regex problem 4 60
I've just discovered very important differences between Windows an Unix formats in Perl,at least 5.xx.. MOST IMPORTANT: Use Unix file format while saving Your script. otherwise it will have ^M s or smth likely weird in the EOL, Then DO NOT use m…
Many time we need to work with multiple files all together. If its windows system then we can use some GUI based editor to accomplish our task. But what if you are on putty or have only CLI(Command Line Interface) as an option to  edit your files. I…
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…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now