MySql

[Anon]

hello Everybody,

Without having subqueries in MySql how to solve complex quries.Is there any alternative
and how to control the concurrency access in MySql.

subbu.

[mwilson]

Well, there are more complex methods of doing this, but if your wanting just a quick fix kinda thing, how about using something like;

// start of scripts
$reg = lower(implode("|", explode(" ", $search)));
$q = mysql_query("SELECT * FROM pic WHERE lower(descript) REGEXP '".$reg."' OR lower(blurb) REGEXP '".$reg."'");
// rest of script

This saves time on a loop constructing a big long; $query .= " OR blah blah"; for each word in the search string, although personally I opt for alternate methods, these are perfectly viable and hold the basis of simple querying for keywords.

[Anon]

Did you try something like this?

SELECT col1, col2, col3 FROM tableA, tableB, tableC WHERE tableA.col1 = 'something' AND tableB.col2 = 'something other' AND tableC.col3 = tableA.col2;

[mwilson]

Hmm, I can't help but think i've posted this to the wrong thread 😛