Search:

OK, maybe I didn't describe my problem the right way, or I am now making some progress figuring it out by myself...

Here's my need:

I have a table, called attributes, which contains just 3...

I'm using mySQL, and I believe it is version 5.0.22, not sure about it but that's the info I see when I access it through Sequel Pro...

Also, when I think about it, I am not sure it is an UPDATE...

Yes, precisely, that's what I'm looking to accomplish. But I get lost in my 'WHERE' clause since I'm looking to affect 'rows' (attribute 33, and 34) for each userid WHERE attribute 14 is LIKE...

Table name : attributes
Only 3 fields: userid, attributeid, value

Table before required UPDATE statement :
userid attributeid value
1 14 2000-11-29
1 ...

Duh!

Sometimes we really 'think it too hard'... OK, this one is closed. Let me add this tidbit for other's future reference: since I have rows with names different than 'att', and I didn't want...

Dear NogDog,

It works at my end. That's for the 'one-row-at-a-time' update. What if we wanted to update all 14 rows in a single query, say for att1 through att14 ?

Also, on a theoritical...

Hi NogDog,

No, no, no... sorry... let me clarify. The data parts of my example are just to reflect 'some data'. You should view them more as variables, not as the actual data itself. I just...

This did it for me.

Thanks a lot Bear.

Marco

Here's my table structure:

Table1
id, name, data
1, att1, Lorem ipsum 1
1, att2, Lorem ipsum 2
1, att3, Lorem ipsum 3
1, att4, Lorem ipsum 4
2, att1, Lorem ipsum 1B
2, att2,...

I've just posted a more specific question about the equivalent of EXCEPT clause for mysql, but I would like to get help on the right keywords to search for in order to learn how to perform...

Table = SUBSCRIBEDLISTS
Fields = userid, listid
(All users can subscribre to many lists)
Example:
1, 1 (user 1 subscribes to list 1)
1, 2 (user 1 subscribes to list 2)
1, 3 (user 1 subscribes...

Newbie question here for what I think requires a 3 table join query.

I'm close, but I just can't seem to figure it out through search, wikis and howtos...

My tables:

USERS (pkey = id)...

Hi,

I am a TOTAL newbie to PHP. Using it mainly for a few forms handling (through purchached scripts) and managing our customers database with PHPlist. So far I've been successful installing and...

Hi,

I am a TOTAL newbie to PHP. Using it mainly for a few forms handling (through purchached scripts) and managing our customers database with PHPlist. So far I've been successful installing and...

Yes I did and it works fine. Except when I used the JOIN query, I was able to use the alias name (e.g. cust_city in this case) and the query worked fine. Now it seems like I can only use the...

Thanks Jon, it works very elegantly :-)

Now if I pushed my luck and wanted to use a WHERE clause to find a subset of users, what would be the appropriate synthax ? I tried using:

WHERE...

I have a fairly simple join query (eventually a view) that I would like to be able to create. Here's a quick glance at my tables and fields:

Table1: USERS
Field1: id
Field2: email
(and a few...

I already tried OR rather than AND, and the query seems to 'loop', it runs forever, not returning any results nor error message...

Hi,

I'm trying to build a join query between 2 tables using the following synthax:


SELECT
id,
email,
a1.value AS first_name,
a2.value AS last_name,

Thank you so much NogDog, this is EXACTLY what I've been looking for, for way too long before finding this forum! I can now understand the logic of my tables and query them as I please by trial and...

Hi, I'm fairly new to SQL, using MySQL 5 with PHP 4, and PHPList to be more specific. I am access my tables and creating queries directly using SQLyog client. Since I don't even no how to 'name' my...