database query

thanks for taking the time to read this. Essentially I have 3 tables. Posts, Follows, Artists. What I am trying to do is pull all the 'Posts' from…

After taking some advice from people on here in a previous thread, I'm trying to convert my MySQL to PDO, but am running into some issues. Here is…

I have a User collection in mongodb and am using lift/scala to do User.findAll operations and retrieve the number of users that were created within…

what i am trying: SELECT `update_photo`, (SELECT substring_index (`username`, ' ', 1)), `id_user` FROM users JOIN worker_has_profession ON…

i need to select only the first name (that is the first word) of the user. For example, Andy Jones, only select Andy Any idea? thanks

This is a document: { title:"Happy thanksgiving", body: "come over for dinner" blocked:[ {user:333, name:'john'}, {user:994, name:'jessica'},…

having a little trouble with this query. I have two tables ... Account - ResourceID (int) AccountID (int) (unique auto-inc) Resource - TextName…

I want to find table row from database depending on the value which is nearest to the given value. I have following data Id Rate Fat 1 10 8.00 2 20…

I'm implementing an advanced search for a records in a table (let's call it "product") that is linked to many tables. Main Table "product" id |…

I have a situation in which I need to select all values and the query is like select sr.*,cs.subjectid,cs.priority,cs.subjectname from sometable sr,…

Basically I'm trying to combine two tables together into a new table. The first table contains information on users and the second table stores…

I have many products (product_id). Users (user_id) view the products. I want to query which users viewed whatever product in the last 24 hours . (In…

I am working on a C# application that writes to a database whenever new info comes in through a file. Then, when the user wants to get some specific…

This is the query I am currently executing: SELECT * FROM `datalog` WHERE world_id IN (2) AND action IN (0,1,2,8,9,10,11,13,14,15) AND x = -184.0…

When i run either of the queries below with a normal 13 digit barcode a result is returned from my database perfectly fine. However when i run the…

I have a MySQL query that looks like this: select scheduled_hike_id , organizer_member_id , hike_attendee_id , mileage, feet_elevation,…

I have inserted a lot of information into a SQlite database from my program. Now, my small task is to look up the database and find some statistics…

i am trying to use this query but i get this error: Warning : mysqli_stmt::bind_result() [mysqli-stmt.bind-result]: Number of bind variables doesn't…

I am trying this query, but didn't work INSERT INTO single_user (location_home.id_location_home ) SELECT location_home.id_location_home WHERE…

Hi I need help with a database myql query. What where clause can I use to select records that are one hour or younger using a DATETIME timestamp?…