Tagged Questions
1
vote
0answers
19 views
MySQL Fulltext Search Over Linked Tables
I'm trying to search a MySQL database using MySQL's fulltext indexing. However, the tables I need to search are linked as such:
--------------------- ------------------------ ...
1
vote
0answers
113 views
Search zipcodes within a given radius
I have the following code in the header.php file for my website:
<?php
mysql_select_db($database_ecsdb, $ecsdb);
$query_getCat = "SELECT DISTINCT category FROM food ORDER BY category DESC";
...
1
vote
0answers
134 views
How to do an advanced search in php?
I want to do a form so that users of a library can do an advanced search. I thought I could use the values hard coded in my form and append them to the query (they come from select fields). I also ...
1
vote
0answers
81 views
Search vendors by checkbox and select options
I have a list of vendors like this (as picture bellow)
http://www.pkbazaar.com/classifieds-house-real-state-sale-buy-lahore-karachi.php
Now can I want to search vendors by "service provided", ...
1
vote
0answers
85 views
mysql fulltext boolean search with asterix
I have a query like below:
SELECT prd_id FROM products WHERE MATCH (prd_search_field)
AGAINST ('+gul* +yetistiren* +adam*' in boolean mode);
This doesn't return the rows including 'gul'.
...
1
vote
0answers
83 views
weighted mysql results from matching 2 columns accross 3 tables (3rd being joining table)
Ok, I'll do my best to explain this clearly. I am at a loss as to what to do next. I'm building a D.A.M (digital asset manager). I have a table of Assets, a table for tags, and asset table to join the ...
1
vote
0answers
120 views
mysql fulltext colums priority
How can I set priority for multiple columns in mysql fulltext search ?
SELECT ID, POSITION, DATA, DATE_FORMAT(DATA, '%Y-%m-%d') AS DATE
FROM VACANCIES
WHERE VACANCIES.VISIBLE = '1'
AND ...
1
vote
0answers
108 views
Sphinx --buildstops how with special chars?
I am using SphinxSearch service for creating a searchable index and it works great... superfast with relevant results!
now we want to fnish opur autosuggestion tool and would like to mine popular ...
1
vote
0answers
165 views
SQLAlchemy / MySQL Search Algorithms
I have a Pylons app running on SQLAlchemy over MySQL. I have a data model with over 26,000 entries. These entries have titles (Unicode(256) columns) and I would like to be able to search for a title ...
0
votes
0answers
40 views
MySql database design for website
I am new to MySql databases and need your input on if this is a good setup or not, for a classifieds website.
The website will have different attributes for different categories.
I have so far, ...
0
votes
0answers
42 views
ID fields in database tables or GUID?
I often use for the ID field for a quick access or a search operation and also use it as INDEX field, also it has such properties as PRIMARY_KEY, AUTO_INCREMENT.
But I wonder, how could be long INT ...
0
votes
0answers
58 views
MYSQL sum values from multiple column searched with regexp
my table "tabli" is
id|sweg2345_etov|ldogj35re_etov|xcsd2WE_etov|SID|name|.........|total
1 | 3 | 2 | 5 |d5 | Ab |.........| 10
2 | 1 | 3 | 4 ...
0
votes
0answers
88 views
How to search a string variable in a database (compare if exists) MYSQL
I need a function which compares a string variable which is already declared. It has to search for the string in the database and when its found it needs to copy the data to somewhere such as to ...
0
votes
0answers
20 views
Search by many attributes in e-shop
I`m working on e-shop website and my current task is to make search in product catalog by attributes. So product category attributes differ from each other. Relationships between category and products ...
0
votes
0answers
230 views
php + mysql + search query
i am creating a search form that will allow users to select from a drop list a country or a name than the system will search in the database and select the appropriate info and display it on the ...
