Search The Whole Database
Is there a way to search all tables in a database for a keyword using 1 query?
Something like SELECT * FROM ??? WHERE ..ummm you know what,,I cant do it ,,please help
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Search: Remove Quotes From Database For Search
I am making a book site and currently in the database are book titles likes "John's Trip" and "Peter's new bike". I have a search function where the customer can type in "Peter's" and it will bring up everything with "Peter's" in it. But i was wonderind is there any way i can search for "Peters" and "Johns".
Database Search
how to setup a search engine for my database. Right now I have 4 different tables, all relating to each other thru different keys. I currently use a search for where you must use drop downs to fill in text fields. I want to change over to a search system that is just one text field that searches all the fields. First question, do I need to create an additional table for keywords? If so, how do you keep that up to date? I get photos and information added every hour. Do I need to look into a full text search or something different than the simple search/where?
Database Search
I am looking for a query that will search all of my database without having to use all the individual table names and fields as there are 6 tables and over 30 fields in the database is there any special expression for this the search criteria would only be one word.
Search & Replace In Database?
I want to change a website from XHTML to HTML, so I have to get rid of my closing tags, such as... <meta tags /> <image src="" /> <br /> I can clean up most of my site with Dreamweaver's search and replace function. Is there a way to do something similar with my database, preferably using phpMyAdmin? If so, will it let me use regex (for meta tags and images)? Also, I know how to use phpMyAdmin's Search function, but is there a way to search for a specific item in a field, like " />" or "<br />"?
Search Database Query
I am looking for a query that will search all of my database without having to use all the individual table names and fields as there are 6 tables and over 30 fields in the database is there any special expression for this the search criteria would only be one word.
How To Search Mysql Database Using Php
in my mysql database table, i have 1. "this is mysql practice search test" 2. "that was my mysql practice search test" if i use ** "SELECT * FROM `table` WHERE `def` like '%mysql%' order by id" it returns both rows but .. if "SELECT * FROM `table` WHERE `def` like '%mysql my%' order by id" doesn't return anything. how to search table with more than one word from that may be in same field or different field of any row of table.?
Very Basic Database Search
Have a very basic database of contacts that I want to make searchable via PHP. Have successfully constructed the database, and can connect and get a basic search, but not sure how to get what I want. Table name: Business Fields: ID (key),Name,Address,City,State,Zip,County,Region,Phone,Fax,Email,Category (4 main categories),Type,Web,Contact Vision for search page: unified search, possibly with Category field being main selection (checkboxes, maybe), then refining search by City, County, Region, Type only. Results will be set off in a <div> to the right.
Techniques Available To Search A Database
Can someone provide a list of the most common techniques used to search a database for matches based on user-entered keywords etc? At this point the only SQL syntax I'm aware of to search a db is using the LIKE clause: SELECT article FROM mytable WHERE article LIKE "php variable"; Is this an efficient enough way, even for a large table? For example, what kind of algorithm do commercial scripts like VB or blog use to search its content?
Database Search Approaches
can i put together a site search tool for a e-comerce site that draws from a mySQL database. They are currently using a tool (Swish-e) that relies on an index of their site. I don't know a lot about searches & it got me wondering if it is faster to query the database directly or may a daily index and search that, like they are currently doing? I don't believe they get a ton of hits on their search engine. I think they get around 120 orders a day, if you can deduce anything from that. I'm also curious about the flexibility I would have to modify the way the program searches in the future. If I were using an indexed version it seems like it might be hard to produce advanced searches (all <color> tv's from <manufactuer>)
I Have A Search Form To Search Through The DB.
I have a DB with 50,000 entries. I have a search form to search through the DB. If the recno=30123456 and you search the recno, you get that one file. what if i want a query that searches alll recno's that contain 30?? Can I do that using mysql or do I need to program that in my java app?
Database Transfer Between Oracle 8 Database And MySQL Database
Is it somebody out there who has made a migration from an Oracle server to an MySQL server?? The scenario is as simply: I've got a Oracle 8 server with a database with content that I want to transfer to a MySQL database. No special data, constraints etc that MySQL not will handle. My solution is to reverse engineer the database from ERStudio and then produce a SQL script that will insert the data into the MySQL engine. But I can't do this, because the customer want me to do a PL/SQL script that does this, even if he never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ?
Best Way To Search
I am a little confused on the best way to search a mySQL database with PHP. Which is better? 1. Search with LIKE and a trimmed term SELECT * FROM tablename WHERE field1 LIKE "%$trimm%" OR field2 LIKE "%$trimm%" OR field3 LIKE "%$trimm%" ORDER BY field1 DESC 2. Using mySQL's 'match against'
Search WHERE SUM
What would be the proper way of generating a query like the following; SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id; Assuming the table looks like this; Sales: Id| totalsales| monthyear 1 | 100| 2003-09 1 | 10000| 2003-08 1 | 2000| 2003-07 2 | 30000| 2003-05 3 | 10000| 2003-06 3 | 10000| 2003-05 I want the query to return id 1 and 2 as the sum of their totalsales is smaller then 20000.
DB Search
I am working a search tool for users to find members based on First Character of lastname. How can I have mysql or PHP only look at the first character of the string?
Search
I have an ASP page that searches a database. Although the entire database is searched, I use a filter on certain fields. The below filter (I could only use a little bit for the post to work)is for a field [LEDef_ActiveInd] that has either the number 1 or 2 or the text of true or false and it works and returns all "LEDef_ActiveInd" that carries the value of true. ..strQS = ..strL & "...LEDef_ActiveInd+true nd all+" & Trim(strR) What I would like to do is also filter a field [LEDef_Cd] which has text data such as "10-Name" or "40-Name", etc. I need a filter/code that would return the results of all the "10-Names".
My SQL Search
I'm currently using the following mysql statement to perform a search. Right now it is only returning the results which are found in the description field. How do I modify this statement so that it is searching the following fields: company_name, product_name, description. SELECT product_id, company_name, product_name, url, description FROM product, company WHERE product.product_id = company.company_id AND description regexp '#FORM.query#
Search
i have several tables. they have some fields in common, but some different ones. table 1 id author title journal year 1 brown java computing 2005 2 black sql database 2000 table 2 id author title publisher year 1 brown c++ pen 2006 how do i search both tables for i.e. author ? the author can exist in only the one table or both. so if i search brown i get: id author title journal year 1 brown java computing 2005 id author title publisher year 1 brown c++ pen 2006 if i search black i just get : id author title publisher year 2 black sql database 2000
Search
I have a search box on my site which works fine but I would like to improve. at the moment it will not return a result for a two word search unless those words are adjacent ie red box but not for return for red big box I would like to make it give results for multiple word searches when the: words are found In this order all words in search adjacent all words in search (not neccesarily adjacent) any of the words I assume the following tells it what to look for and how to display results (I hope so any way) Code:
Search Box
I am trying to have a search box on every web page in the site - like everybody seems to have these days, anyway, according to DW help the search page results holds the key to how it searches the database, but the trouble I am having is what to put in the sql box for the query? I know SELECT * FROM table will select everything and I know SELECT * FROM table WHERE location = 'town' ORDER BY price etc,etc. But what I need to know is how to have the results page display one set of results if a user enters one topic in the search box and another set of results if something else is entered. And if there is nothing to display, how do you configure that?
SQL To Use For Search
I am creating a script that searches the table "sites" in the database "actionhostsearch". I have a column in my table called "keywords" and i want to check that against my entered text, I am currently using LIKE but don't get a good result, is there a way I can refine it? The keywords are space separated, but i want it to search like multiple keywords. Is there anyway of doing this or would i have to separate the keywords out using php?
Search WHERE SUM
What would be the proper way of generating a query like the following; SELECT id FROM sales WHERE SUM( totalsales) <= '20000' GROUP BY id; Assuming the table looks like this; Sales: Id| totalsales| monthyear 1 | 100| 2003-09 1 | 10000| 2003-08 1 | 2000| 2003-07 2 | 30000| 2003-05 3 | 10000| 2003-06 3 | 10000| 2003-05 I want the query to return id 1 and 2 as the sum of their totalsales is smaller then 20000.
Search
I've heard that a friend searches by using a "like" querywith a select... But i searched in the mysql manual, and gcoudlnt' find anything on it... What are some other methods of searching in mysql databases?
SQL Search
I am migrating my site over to mysql and was wondering how I can implement my same type of search into the territory of mysql. Basically this is how the search worked for the db files (terribly inefficient but it worked well). Spliting each line at the deliminator, it would match the query against 10 different values and depending on the value being matched if a match was found the item would get a score. Each column had a higher score depending on which was most important. I basically used a regex expression to count the matches and multiply it by the matchscore. Is there anyway to use LIKE and find out how many times it matched? Can I use REGEXP and get a match count with the global switch?
Using LIKE In A Search
First off, I apologize if I am in the wrong forum. My question is kind of simple, if I use "SELECT from INVENTORY WHERE item_desc like '%blue%' OR item item_desc like '%stand%'; can i assume that LIKE is "not" case sensative????? so far that is the case, however, I can't find where in the documention to make sure of it. doing a search for LIKE in the documention is just ever so special. so i want to ask people who know. is LIKE case sensitive, or not?
Search EVERYTHING For ANYTHING
I got a database here with multiple rows/columns inside. Example: I have columns date, text1, text2, text3, and so on... Select * from db where "%" = "1969" So I wanna search EVERYTHING in the db for ANYTHING that says 1969. Whats the query to do this?
Search?
I builded a little propert database. I added a search function to the site but have the following problem: I used "SELECT * FROM table1 WHERE area ='province' and type like'%type_1%' and town like'%town_1%' and descr like '%descr_1%' and suburb like '%sub_1%'" But it do not do the like thing. If I search for 3 bed and the actual data is 3 bedroom it gets the data, but if I search for 3 bedrooms (extra s) it do not get it or if I make spelling mistake I do not get a result either. So it seems that it rather search for the exact term instead of the like term. How can I get it to really search for only a phrase, part of a word or a spelling error?
Using LIKE To Search
I have been using the following to search: WHERE FirstName LIKE '%$firstName%' AND LastName LIKE '%$lastName%' AND Email LIKE '%$email%' AND EmployerLocationName LIKE '%$venue%' AND State LIKE '%$state%' AND MemberApproved LIKE '%$status%' AND tblmanager.mngNBR LIKE '%$mng%' It has been working well but the only thing I realised with the mngNBR, if the user selects say 'Joe Bloggs' and in the database he is number '2', it also outputs all the results of other managers who have number '2'... so Matt Smith '22', John Smith '24'... I'm assuming this is because I have used like but is there any other way I can do it?
Search Using LIKE
I need to pull all records where the First letter of each word in the record begins with the entered variable. Here's my query: CODE"SELECT * FROM hgs_contacts WHERE name LIKE '".$_GET['l']."%'";
Search Between A - J
I been looking a ways to do this but I can't seem to do it or get my head around it. I want to basically search my table for all "titles" begining from A - J. I want the SQL to check the first letter of the "title" and if the first letter starts with any letter between A - J I want it to be displayed. How would I do this? So far I have: Code: SELECT title FROM pmc_keyclients WHERE LEFT(key_title, 1) = 'A' But this let me search BETWEEN latters
Search By Number
I have a question regarding a mySQl search Basically I have a list of numbers stored in a field in my database representing different features of a venue For example 1,16,17,10,8,13, Now I want to give my client the ability to look for specific venues with a specific feature by typing in the number for the feature they are looking for, ie if they want to find all venues with a bar and 1 = bar then they enter 1 into the search and are presented with all the venues with a bar Now my problem is if I do a search for Ƈ' using LIKE then and a wild card (ie %1%) I will get all the features that have a 1 (ike 16, 17, 10, 13). Is there anyway I can write a search that will only return venues that just have the number 1? Also the numbers can appear in ANY order so it might be 10,8,26,1,32 ....
Search Index
I have text stored in a database that I'd like to be searchable. However, searching through long strings and blobs seem like a very inefficient way of doing things. In MS Server there's an index server that will take all strings and create indexes out of words. This can significantly speed up text searches. Is there such a feature or tool for MySQL?
Fulltext Search
Below code is from a CMS's search script. When you search for plain words like Britney Spears it displays the results correctly. But when you search for a URL like http://www.sitepoint.com then it does not return any results. Is there anything wrong with the following SQL code? ... $this->sql = "SELECT story_id, story_date WHERE $where $sterms "; ... $where = " MATCH (story_title, story_url, story_tags, story_content) AGAINST ('$words') "; Note: story_url stores URLs exactly as http://www.sitepoint.com not encoding etc. story_url field is FULLTEXT same as others.
Search On Dates?
I have 2,000 stories saved in a database (Not my DB) and I want to perform a search on the section of story and the date it appeared on the website. The trouble is the DB is dodgy and dates are saved in a format like: 2007-1-8 //Today Ie YYYY-M-D Now what I want to do is perform a MySQL statement whereby I perform a search on the date in this format: 2007-1-8 //Today Ie YYYY-M-D IE: "Y-n-j" And then my SQL finds the date I asked for, but then - Checks it’s not greater than today’s date (NOW) by using unix_timestamp on both the appreared field and published field. And then output all the results to the screen. Now I thought this may work: PHP $sql = "select id,headline,appeared from news_stories where section = '$searchstring' AND date_format('$appeared','%Y-%m-%d') = date_format(appeared,'%Y-%m-%d') AND unix_timestamp(published) <= unix_timestamp(now())";
Search Functionality
When a website adds search functionality, more so than bulletin boards, but take the Facebook for example (not as complex as what they do but a good example, and the only i can think of at the moment). You can do a basic search for 'John' and the results returned will contain people named John, it will contain people who date a John, anyone who remotely has 'John' show up in any field in their profile. Is the query for this simply a matter of a large amount of OR statements is there something else to it?
Search & Replace?
Newbie here. I have a DB with two tables. Table 1 has three fields - a unique ID#, a first name (i.e - John), and a last name (i.e. - Smith). Table 2 had many fields, one of them being a first name/last name combination (i.e. John Smith). I want to replace the first/last combo field in table 2 with the unique ID# from table 1 which matches the concat of the first name field and the last name field from table 1. I know I can do it by hand, but there are thousands of them in table 2 that need to be replaced and the data in table 2 is in the format that I will be receiving from an outside source, so I will need to search & replace this data on a regular basis.
Help With REGEXP Search
I have a database of English words. This thing is huge. Which means that when I do a search like SELECT word FROM wordlist WHERE word LIKE 'k__p' I get almost 300 results. What I want to do is limit my results to only those words with a repeated letter taking up that middle spot, e.g. "keep" but not "kelp". Is there any way to do this in a MySQL query, or am I stuck doing this in my application (which is what I'm currently doing)? I've tried some REGEXP tricks I know, but MySQL REGEXP apparently doesn't have capturing subpatterns or backreferencing.
Search-function
Does anyone happen to know how to select info from the database based on multiple strings like so: SELECT title FROM food WHERE title LIKE '%New%' AND WHERE title LIKE '%York%' AND WHERE title LIKE '%restaurant%'
Add Search By Tags.
I have this setup where in 1 table i've got the content and name, and I currently have a search for them, but I also have a tags table that i would want to search, then return not the tag, but rather the row from table a associated with it. HTML TABLE 1 - content id name content TABLE 2 - tags id content_id tag I have 2 problems. a) if i do "SELECT content_id FROM tags ..." and i get a list of all the matching id's, how to i write a query to return them all? and isn't there a more efficiant way of doing it? like if the search result returns like 200 id's, isn't calling them one by one too much. Another problem i'm having is that sometimes one row of content might have more then 1 tag that match the search criteria, so it will end up being called twice. how would i prevent that?
Search On Keywords
I have a table which stores keywords as a comma separated list. The records are like 1) Ad Name | car rentals, car advertising 2) Ad Name | car, bmw, bike I would want to search for 'car' and would like to have only the second record listed and not the first record. But our usual query where keyword like '%car%' wouldn't work here. Is it possible to split these keywords in the query itself and then make it work?
Problem With Search ( Need Help )
Here, i'm having one record in database with rc_title field: and it have the value: rc_title: abcdef so then, i want to make the query to search out this record with this keyword: abcdefgh so it can be true?
Search And Purge
Just wondering if there is an easy way to search and purge a pattern from a set of results? I have inheirited a rather large database with a crappy front end. As a result I have a bunch on <br> from users hitting enter in the entery field. I want to erase them. I can run a query that returns all the results but I am not too sure how to edit them.
Search And Replace
I want to replace a string inside a text field named "text". Here is a query which would show the records which contain the offending code which I want to strip out: SELECT * FROM articlestable where text like Concat('%', '<b class=titler>', '%', '</b>', '%')
Employee Search
Splitz General Marketing - Employee Search Seeking employed/unemployed persons for a part-time positon. Must be hard working and willing to learn. Good paychecks, allowances and higher job opputunites are applicable to this position. If you are interested in this job offer please contact us for more information. Subject to our satisfaction with your resume you'll be filed in. Principals only. Recruiters, please don't contact this job poster.
Search Using 2 Tables
ive 2 tables: static & new and both with the same structure and indexing - these work: $query = "SELECT lat, lng, html, label, icontype, display, advert, banner, banner2 FROM static WHERE MATCH(display) AGAINST ('" . stripslashes (str_replace (""", """, ($_GET['name']))) . "' IN BOOLEAN MODE) ORDER BY label ASC "; if i change to "new" then this works: $query = "SELECT lat, lng, html, label, icontype, display, advert, banner, banner2 FROM new WHERE MATCH(display) AGAINST ('" . stripslashes (str_replace (""", """, ($_GET['name']))) . "' IN BOOLEAN MODE) ORDER BY label ASC "; if however i change it to FROM static,new - nothing happens
Search A SET Column?
I have a table with two columns, the first column is of type VARCHAR and the second of type SET. column1(VARCHAR)column2(SET) person1group1 person2group2 person3group1, group2 I want to retrieve everyone in "group1"... > SELECT * FROM mytable WHERE column2 = 'group1'; Which returns only person1 and not person1 and persom3 as I want. I have searched through the manual and found several ways to search for data matching several criteria (ANY, IN, SOME, ALL) but not "the other way around". I guess what I'm really asking is how do I search within a column of type SET?
|
TRACKER
