UPDATE ... FROM query

I have these tables: CREATE TABLE stack ( ProjectID INTEGER NOT NULL StatusID INTEGER NOT NULL ItemNumber INTEGER NOT NULL Stamp DATETIME NOT NULL ); CREATE TABLE queue ( ProjectID INTEGER NOT NULL StatusID INTEGER NOT NULL ItemNumber INTEGER NOT NULL Stamp DATETIME Wait BIT NOT NULL ); And

Using LIKE to search for occurence of a column value in a string

I wan't to search for all rows that match a value. I have these rows: URL Name 'http://www.microsoft.com/kb/' Microsoft Knowledgebase 'http://www.microsoft.com/search/' Microsoft Search Now I wan't to find all occurences where any of above URL

RE: Using LIKE to search for occurence of a column value in a string

Thanks! I know I'm searching for for a long string within a short string - but that's why I reversed the expression from column LIKE(value) to value LIKE(column) But I think I just might go for your solution using the LOCATE function as it seems to better fit this specific need. /Jakob

RE: JOIN on same table

SubProject_210 4 1 What could be wrong? Best Regards Jakob Vedel Adeltoft, CTO [EMAIL PROTECTED] WebProof - www.webproof.dk Tel +45 46 32 68 68 Fax +45 46 35 94 94 -Original Message- From: Uttam [mailto:[EMAIL PROTECTED

RE: JOIN on same table

are still able to inherit from the parent that breaks the node - but then they only inherit information from this parent and not from the root. Best Regards Jakob Vedel Adeltoft, CTO [EMAIL PROTECTED] WebProof - www.webproof.dk Tel +45 46 32 68 68 Fax +45 46 35 94 94 -Original Message- From

JOIN on same table

Hi there, I have this table: project_group_idref_project_group_idnameroot_project_group_id node_depth inherit 10 0 ProjectA0 0 0 57

Looping through parent and childs

I'm new to mySQL and would like to know how do a SELECT where I get all child records whose root parent=1 Here's my table (project_group_list): group_idparent_group_id 1 0 2 0 3 1 4 3 5