I was actually asked this myself a few weeks ago, whereas I know exactly how to do this with a SP or UDF but I was wondering if there was a quick and easy way of doing this without these methods, I'm assuming that there is and I just can't find it. A point I need to make is that although we know what characters are allowed (a-z, A-Z, 0...
I have table where in a table called test which have 4 fields.one field named as listing, I have 1,2,3,4,5,6 multiple values separated by comma, I need to check whether in that table and in that particular field an id say 4 is there or not.. by a sql query. ...
how to form a query to select 'm' rows randomly from a query result which has 'n' rows. for ex; 5 rows from a query result which has 50 rows i try like as follows but it errors select * from (select * from emp where alphabet='A' order by sal desc) order by rand() limit 5; u can wonder that why he needs sub query, i need 5 differen...
Hello All, I am having a table orders orders ( id int unsigned not null, fcr_date TIMESTAMP, completion_date TIMESTAMP, factory_no varchar(255), vendor_no varchar(255)) Please ignore the data type typos if any. I want to write a sql query that helps me filter the data per vendor factory. The data to fetch includes the number of ...
Hi, I'm inexperienced with SQL... i'm trying to figure out how to search my database for personnel with specific skills. I want to generate a table which contains two columns, Name and Skill(s) The initial search is currently performing this query: SELECT * FROM User_Skills LEFT JOIN skills ON User_Skills.Skill_id = Skills...
I am using zend framework. I am using following query in zend and it is working for me perfectly. $table = $this->getDbTable(); $select = $table->select(); $select->where('name = ?', 'UserName'); $rows = $table->fetchAll($select); Now I want to create another query in zend with 'like' keyword. In simple SQL it is like that. SELECT * ...
I run a lab annotation website where users can annotate samples with tags relating to disease, tissue type, etc. Here is a simple example from models.py: from django.contrib.auth.models import User from django.db import models class Sample(models.Model): name = models.CharField(max_length = 255) tags=models.ManyToManyField('T...
I need to lookup all my products (sku's) their latest stock quantity. I have one table (called "stock") with 315k+ records containing this information (a new batch of data is added every day, for most sku's). The reference data is in another table (called "stockfile"). This is the query to do it: SELECT s1 . * , f1 . * FROM stock s1 JO...
I'm trying to figure out a way to allow users of my application to define their own queries or filters that can be applied to a collection. I want to eventually provide an intuitive user interface to create these filters (see image below), but initial it would be OK if a user had to type of a text query string. I'll also need to be able ...
Hi, I have the following table: Table +----+------+-------+ | ID | Name | Group | +----+------+-------+ | 0 | a | 1 | | 1 | a | 1 | | 2 | a | 2 | | 3 | a | 1 | | 4 | b | 1 | | 5 | b | 2 | | 6 | b | 1 | | 7 | c | 2 | | 8 | c | 2 | | 9 | c | 1 | +----+-----...
I have an old database that I am inheriting. The access rights are not clearly defined anywhere and I'm looking for a quick way to get them for everyone. Let's say I have a user in my database that does not belong to any membership roles. However, they have been given access to do specific things to specific tables. For example, they can...
I recently ran across some code which the person did the first one. Would like some thoughts on if the top one is better or why a person would write it that way? Any positive reasons over the bottom way. $result = mysql_query($query)or die("Obtaining location data failed!"); for ($i = mysql_num_rows($result) - 1; $i >=0; $i--) { if (!...
I have a quick question about a select statement condition. I have the following table with the following items. What I need to get is the object id that matches both type id's. TypeId ObjectId 1 10 2 10 1 11 So I need to get both object 10 because it matches type id 1 and 2. SELECT ObjectId FROM Table WHERE TypeI...
hii i am new to iPhone, I am using sqlite3 as my database. There are two tables in database as FriendInfo and ItemInfo. FriendInfo contain FriendId and some other field relative to friend info which are quine in this table and ItemInfo contain the ItemId as primary key and friend Id as Foreign Key, i want to execute the join query which...
I have 3 tables: 'cards', 'tags' and 'cardstags', where cards HABTM tags Question: What query do I execute on the 'tags' table to count the number of associated 'cards' rows? I'm looking for something like this: tags.name | count ----------+------ cricket | 15 (15 cards are tagged as 'cricket') soccer | 23 football | ...
Short database description "Ships": The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) Ships in classes are arranged to a...
I'm trying to use get_or_create for some fields in my forms, but I'm getting a 500 error when I try to do so. One of the lines looks like this: customer.source = Source.objects.get_or_create(name="Website") The error I get for the above code is: Cannot assign "(<Source: Website>, False)": "Customer.source" must be a "Source" ins...
I have a paginated list of articles that needs to be sorted by rank but when an article has position <> 0 then it must be inserted in that specific position. I thought that I can at least have the articles with the correct position extracted for the current page and then sort them in PHP to show then in the proper position. I want to do ...
I am trying to figure out the most efficient way to format this query. I have three tables - Transaction, Purchase and Item. The desired result is to select sales data (quantity/sales total) for each item for a specific client. the tables are formatted as follows: (=primary key)* Transaction: Transaction_ID*, Timestamp Purchase: P...
I am trying to print a selected value, is this possible? Example: PRINT SELECT SUM(Amount) FROM Expense ...